Deleting existing record from the oracle

[Former Member]

My sender is a proxy,there is one field here which changes say cfield.Xi doesnot send some records if the change field status is 0 or 1 or 2,for other records it sends data to to the JDBC Receiver.When the Sender Cfield status changes from 0 or 1 or 2 to other values,only this corresponding record must be deleted from the the receiver JDBC.How to do this?

Thanks,

Srinivasa

[Former Member · Accepted solution]

Hi Srinivasa,

Use the JDBC receiver document format with action DELETE.

1) Develop Mapping Program in such a way that it creates Statement only when it is not 0,1 and 2.

Use the Createif function.

2) To delete only the corresponding records map the primary key value to key field

chk this :

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

regards

Ganga

[Former Member]

Hi,

As your using reciver jdbc adapter, pass DELETE in action, if you cfield value is not 0,1 or 2.

Regards,

Sreenivas.