JDBC actions

[Former Member]

.If communications with JDBC using XML format, what are 4 actions you could do?

[Former Member · Accepted solution]

We can also do UPDATE_INSERT

Mudit

[former_member238007]

Hi Satvik,

In sender side the mandatory statements are Query SQL Statement and Update SQL Statement here u can use the option of using INSERT, DELETE, UPDATE, UPDATE_INSERT, SELECT statements in the Query SQL statement, and if u dont want to update any records after fetching u can give simply a TEST in the UPDATE SQL Statement... so that there will be no updation happened to the table..

see this links for more information of JDBC receiver structure and related information..

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

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

regards

Kishore.

[Former Member]

Hi,

Check this

http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/frameset.htm

REgards

Seshagiri

[Former Member]

The actions are SELECT, INSER, DELETE , UPDATE