RFC to JDBC > How to retrieve inserted/updated values?

[Former Member]

Hello,

I would like to know if there is a way to retrieve inserted and/or updated value into a "table" parameter when running an INSERT and/or UPDATE XI query.

Thanks in advance for your answers.

Pierre Lejeune

[Former Member]

I run a RFC from an R/3 system with a "tables" parameter. The RFC is doing an INSERT or UPDATE statement (or both, that's not the question). All I want is to retrieve the values of the "tables" parameter I passed to the RFC.

[Former Member]

Hi,

What u want to do only INSERT the data or UPDATE the data or u want to do both,

if u want to only insert then sert action as INSERT or if u want to UPDATE the use only UPDATE in action or else u have another ACTION UPDATE_INSERT this will update as well as insert the data ..........so use this in ACTION and while using this UPDATE_INSERT then use a KEY feild that should be a unique value in the table.

Check this links.

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30 - File to JDBC

JDBC - http://help.sap.com/saphelp_nw2004s/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

multiple tables with JDBC - http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

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

Regards,

phani

Note:Reward points if it is helpfull....

[Former Member]

Hi Pierre,

can u a lil bit clear....

the scenario will be like... we have an Employee Table EMPTEST with EmpNo and Name. We use a File to pass the EmpNo and the Operator to the JDBC adapter. This will dynamically select the data that satisfies the query from the database and finally push this data back to a file/or it will insert a new set of data...

wat is ur requirement??

In case of JDBC, depding on what you need to perfrom,. INSERT, UPDATE, the datatype will change. To understand this, look into this link,

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

also check this

JDBC Receiver Adapter -- Synchronous Select – Step by Step

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

regards

BILL