Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Designer RDBMS Adapter: Insert Multiple rows
Go
New
Search
Notify
Tools
Reply
  
Designer RDBMS Adapter: Insert Multiple rows
 Login/Join
 
<David>
posted
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?
 
Reply With QuoteReport This Post
Gold member
posted Hide Post
David,
Did you ever get an answer to this question?


iWay 5.5 SMSP1 and 6.0.1 on Intel/Linux
 
Posts: 59 | Location: Birmingham, Blighty | Registered: October 30, 2007Reply With QuoteReport This Post
Member
posted Hide Post
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


iway
 
Posts: 4 | Registered: August 19, 2008Reply With QuoteReport This Post
Expert
posted Hide Post
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


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
 
Posts: 1950 | Location: New York | Registered: November 16, 2004Reply With QuoteReport This Post
Gold member
posted Hide Post
Great, thanks. That may well come in handy one day.


iWay 5.5 SMSP1 and 6.0.1 on Intel/Linux
 
Posts: 59 | Location: Birmingham, Blighty | Registered: October 30, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Designer RDBMS Adapter: Insert Multiple rows

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.