Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

JDBC Receiver side query

Dear Freinds,

I am using Proxy Sender(Asyn) ---> JDBC Receiver(Asyn). I have to update a table in Oracle System based on various conditions.

In R/3 there is a table where i have to pick 2 fields for updation at Oracle System based on 5 other fields.

Now my question is at JDBC Receiver side is it possible to control the UPDATE query according to various parameters being passed for e.g

Assume this is the Receiver side Data Type..

Statement

TableName

Action

Table

Access

SAP_Update

SAP_Prod_Order

Key

Parent_Coil

operation

Coil_No

operation

Sale_Ord_Item

operation

Sale_Ord_No

operation

Prod_Flag

operation

Size_Flag

Operation is the attribute that will be used for the operator.

In some messages Under Access out of 2 fields only 1 might come from sender and also in the Key (where clause) some all fields might come or some could come.

Under these various circumstances will the Update query gets generated properly by the JDBC receiver.

What all i should need to do ??

Please advice.

Thanks & Regards

K.Ramesh

Not what you were looking for? View more on this topic or Ask a question