on 05-02-2006 1:15 PM
hi all;
while configuring the JDBC sender adapter can in any ways we can fetch the tuple from the ODS that has been last added to the table , or in anyway can we give this select query at runtime?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mudit,
You can write your select and update queries in the sender adapter.
The details are avaibale here.
http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm
I hope this is what you were asking
whenever the Adapter polls it makes the query to server.
It gets data by PULL mechanism.
Regards
Vijaya
hi vijaya ;
thanx for your quick reply.
normally while configuring the sender JDBC adap we specify the query like select * from VendorMaster where VendorNumber=000
My question is that weather we can put in the value of the where clause at runtime
Yes u can.
Eg are here.
http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.