after writing to database i want the JDBC response

[Former Member]

hi forum ..pls help....

i have a file-xi-jdbc scenario.... after writing to database i want the JDBC response also...means no. of records updated/inserted/deleted etc.....means no. of rows returned

what can i do....

1. can i do it with a send step using asynchronous interface and ack....but i don know what ack does?

2. can i do it with send step using Synchronous Message Interface to the database?

[Former Member · Accepted solution]

HI,

see the below

JDBC Response /people/swaroopa.vishwanath/blog/2006/12/28/send-rfc-to-sap-xi-150-asynchronous

/people/siva.maranani/blog/2005/09/16/xi-how-to-on-jdbc-receiver-response - XI: How-to on JDBC receiver response

Regards

Chilla

[MichalKrawczyk]

Hi,

>>>>2. can i do it with send step using Synchronous Message Interface to the database?

this is the only way to go with this case

you need a sync call

have a look at this blog:

/people/siva.maranani/blog/2005/09/16/xi-how-to-on-jdbc-receiver-response

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>

[Former Member]

thanks to michal, bhavesh, chandra........... i l just work it out.....

and thanks for "always" answering our queries

[MichalKrawczyk]

no problem

Regards,

michal

[bhavesh_kantilal]

><i>can i do it with send step using Synchronous Message Interface to the database?</i>

yes you need to use a Synchronous Call to the JDBC adapter.

On the basis of the Action ( insert / update , delete ) you will get the count of the number of insert / update / delete etc.

take a look at this link and see what the datatype format for the response would be to make the synch call,

http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Regards

bhavesh