Skip to Content
0
Former Member
Sep 27, 2005 at 03:19 PM

UPDATE/INSERT several rows

200 Views

I have a JDBC receiver

XML SQL Structure is

<STATEMENT> 
  <TABLE_NAME action="UPDATE_INSERT">
     <table>realDbTableName</table>   
     ... 
  </TABLE_NAME>
  <TABLE_NAME action="UPDATE_INSERT">
     <table>realDbTableName</table>  
     ...  
 </TABLE_NAME>
  ... 
</STATEMENT>

But adapter inserts or updates only first entry of <STATEMENT>

Is it possible to define several <TABLE_NAME> inside <STATEMENT>?