Is there a way in designer to insert multiple rows all at once? I am currently reading multiple records in a CSV file, converting to XML, then iterating through each record, creating a new XML to INSERT a single record.

I am told that multiple records are possible, but I just do not understand what the format would be for an XML file containing multiple inserts via the RDBMS Adapter. It appears to expect exactly one record, although the reply contains a "COUNT" tag. Do I somehow need to create a BATCH?

David,
Did you ever get an answer to this question?

Yes, a much more efficient way is to use an RDBMS adapter ITERATE format, which is related to BATCH.

Refer to the RDBMS adapter user guide, around page 81 http://iwse.ibi.com/iway55/documentation/smsp2/i_rdbms_user.pdf

I can't show you the exmaple here because this forum seems to have a problem displaying XML

Hi all,

Here is the sample XML code:

<RDBMS>
 <ITERATE location=”RDBMS/Batches/Iterate/MYSQLSTMT">
  <PARAMS>
   <param0>a</param0>
   <param1>b</param1>
  </PARAMS>
  <PARAMS>
   <param0>c</param0>
   <param1>d</param1>
  </PARAMS>
 </ITERATE>
<RDBMS>

Cheers,
Kerry

Great, thanks. That may well come in handy one day.