Skip to Content
0
Former Member
Aug 08, 2010 at 07:05 AM

XML SQL format for Prepared statements in batch mode

13 Views

Hi

I want to use the batch mode in JDBC adapter for inserting huge volume of records with better performance.

so i need to execute the prepared statements in one batch. Is the XML SQL format for prepared statements below correct ?to<root>

<stmt>

<Customers action="SQL_DML">

<access> INSERT INTO Customers (CompanyName,Address,CustomerID) VALUES($NAME$,$ADDRESS$,$KEYFIELD$)

</access>

<key>

<NAME>IBM</NAME>

<ADDRESS>Street 3 </ADDRESS>

<KEYFIELD>CO</KEYFIELD>

</key>

<key>

<NAME>PWC</NAME>

<ADDRESS>Street 4 </ADDRESS>

<KEYFIELD>NO</KEYFIELD>

</key>

</Customers>

</stmt>

</root>

Please advise