Querry

[Former Member]

Hi

I have JDBC Receiver. I need to update and also delete. Should I use two actions? Do I have to write querry at receiver side? As per my understanding we don't write querries at Receiver JDBC side?

Regards

[baskar_gopalakrishnan2 · Accepted solution]

You can use two actions one for update and other for delete by creating two different statement data structure in target side to take care. If you want to combine both then do stored procedure to achieve this. In this case, you use only one statement.

Refer this[ link|http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm]

[Former Member · Accepted solution]

Do we need to put Query in Receiver JDBC Adapter ?

[Former Member · Accepted solution]

No u dont put any query in the receiver JDBC adapter.

Ur structure will be something like this(if u r using tables):

<MT>

<StatementName1>

<dbTableName action=u201DUPDATEu201D>

<table>Table1</table>

<access>

<col1>val1</col1>

</access>

<Key>

<col2>val2</col1>

</Key>

</dbTableName>

</StatementName1>

<StatementName2>

<dbTableName action=u201DDELETE">

<table>Table1</table>

<key1>

<col3>val3</col3>

</key1>

</dbTableName>

</StatementName2>

</MT>

in case u r using SP, u can refer the link already pointed above for creating structure.

[Former Member · Accepted solution]

Thanks Amit,

I got what I wanted. I have one more doubt. Do we put querry in Receiver JDBC adapter under any other circumstance ? if it's select or insert ?

Regards

[Former Member · Accepted solution]

>>Do we put querry in Receiver JDBC adapter under any other circumstance

No

[Former Member]

You could use a stored procedure call from the receiver jdbc, or perform multiple actions by using the "XML SQL format" protocol. Check the help page below for more info

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

[Former Member]

Do we use SQL Status querry in receiver side for any situation? Or are they used only at sender side ?