Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


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

Read-Only Read-Only Topic
Go
Search
Notify
Tools
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?
 
Report This Post
AdeH
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, 2007Report This Post
iwayjeff
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, 2008Report This Post
Kerry
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: 1948 | Location: New York | Registered: November 16, 2004Report This Post
AdeH
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, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

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

Copyright © 1996-2020 Information Builders