JDBC Receiver adapter ( INSERT/UPDATE with SELECT)

[Former Member]

Is it possible to have following kind of SQL Statement comming out JDBC Receiver Adatpter. If yes what would be the corresponding XML Document format for this.

UPDATE suppliers

SET supplier_name = ( SELECT customers.name

FROM customers

WHERE customers.customer_id = suppliers.supplier_id)

This condition also needs to be applied for Insert condition. Any pointer would be useful.

Thanks,

Samir

[Former Member]

Hi,

Check this JDBC Adapter Configuration Guide:

http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

Thanks,

Boopathi

[Former Member]

You can refer to

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

<StatementName6>

<anyName action=u201D SQL_QUERYu201D | u201CSQL_DMLu201D>

<access>SQL-String with optional placeholder(s)</access>

<key>

<placeholder1>value1</placeholder1>

<placeholder2>value2<placeholder2>

</key>

</anyName >

</StatementName6>

use suppliers.supplier_id as placeholder.

Gaurav Jain

Reward points if answer is helpful

Edited by: Gaurav Jain on Jul 10, 2008 1:20 AM

[Former Member]

Hi

Refer this links,

http://help.sap.com/saphelp_nw04/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/b0/676b3c255b1475e10000000a114084/frameset.htm

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

http://help.sap.com/saphelp_nw04/helpdata/en/4d/8c103e05df2e4b95cbcc68fed61705/frameset.htm

Regards,

Suryanaryana

[Former Member]

Hi Samir,

Please go through the below link for all document formats. You can generate the required SQL statement using the guidelines.

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

-Regards

Shamly

[Former Member]

Hi,

Not sure whether this is possible directly or not, but you can do the same either by

1.invoking Stored Procedure and writing the same inside that or

2.Using message protocol as Native SQL String in your jdbc communication channel in which you can pass native sql string direclty isntead of xml

thanks

amit

reward point if suggestion helps