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