on 06-29-2006 9:29 AM
Hi,
I would like to use the JDBC Receiver adapter in a synchronous szenario where I insert rows in a table. Does the adapter return a response e.g. the number of inserted rows?
Kind regards,
Heiko
hi,
>>> Does the adapter return a response e.g. the number of inserted rows?
yes of course it does
have a look at:
section:
<insert_count>count</insert_count>
on:
http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm
Regards,
michal
-
<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions"><b>XI / PI FAQ - Frequently Asked Questions</b></a>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Yes, you can do this.
Use a BPM and have a SEND synchronous step that is asscoaiated with the RECEIVER JDBC adapter.
Now, the Response will be returned stating the Number of Insertions as INSERT_COUNT.
For every STATEMENT tag, there will be an INSERT_COUNT in the response. So, if you need to calculate the total number of insertions / updations just use a count function from the response.
Take a look at this link,
<a href="http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm">Document Formats for Receiver JDBC adapter</a>
<a href="/people/siva.maranani/blog/2005/09/16/xi-how-to-on-jdbc-receiver-response">JDBC Response HOW TO</a>
Regards,
Bhavesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.