January 15, 2009, 09:20 AM
<David>Designer RDBMS Adapter: Insert Multiple rows
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?
January 28, 2009, 03:48 AM
AdeHDavid,
Did you ever get an answer to this question?
January 29, 2009, 05:09 PM
iwayjeffYes, 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.pdfI can't show you the exmaple here because this forum seems to have a problem displaying XML
January 29, 2009, 05:17 PM
KerryHi 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
January 30, 2009, 05:42 AM
AdeHGreat, thanks. That may well come in handy one day.