Action attribute in jdbc adapter

[Former Member]

Hi

I have been working on jdbc adapter. Till now I have been using action attribute in jdbc receiver adpater for insertion only. Now I'd like to know what are the possible values can u we in "Action"?

[Former Member]

hi sekhar_kireeti ,

please refer sap help and scn before posted thread .

thanks,

[Former Member]

chk this u will get detail description about all the possible actions:

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

[Former Member]

Hi,

s the attribute action with the value INSERT, UPDATE, UPDATE_INSERT, DELETE, or SELECT. If you use the optional <table> element, the value specified is used as a database table name.

1.Action=UPDATE

Statements with this action cause existing table values to be updated. Therefore, the statement corresponds to an SQL UPDATE statement.

The corresponding SQL statement for StatementName1 in the example above is as follows:

UPDATE dbTableName SET col1=u2019val1u2019, col2=u2019val2newu2019 WHERE ((col2=u2019val2oldu2019 AND col4=u2019val4u2019) OR (col2=u2019val2old2u2019))

2. Action=UPDATE_INSERT

The statement has the same format as for the UPDATE action. Initially, the same action is executed as for UPDATE. If no update to the database table can be made for this action (the condition does not apply to any table entry), values of the table described in the <access> element are inserted in accordance with the description of the action INSERT. <key> elements are ignored in this case.

3.Action=DELETE

Statements with this action cause existing table values to be deleted. One or more <key> elements formulate the condition for which table values are deleted.

The corresponding SQL statement for StatementName3 in the example above is as follows:

DELETE FROM dbTableName WHERE ((col2=u2019val2oldu2019 AND col4=u2019val4u2019) OR (col2=u2019val2old2u2019))

4.action=SELECT

Statements with this action cause existing table values to be selected. Therefore, the statement corresponds to an SQL SELECT statement.

5.Action=EXECUTE

Statements with this action result in a stored procedure being executed. The name of the element is interpreted as the name of the stored procedure in the database.

regards,

ganesh.

[former_member184681]

Hi,

The Action depicts the SQL statement that you want to execute, for instance: SELECT, INSERT or UPDATE. Please refer to this article for further details if necessary:

http://www.riyaz.net/sap/jdbc-adapter-configuration/1200/

Hope this helps,

Grzegorz