Skip to Content
0
Former Member
Jan 21, 2008 at 06:52 AM

Problem in Polling the data at sender side using SQL Queries

9 Views

Hello,

Small doubt regarding the concept of poling at sender side,

Can we select the data from one table in the queryStatement field and update the data in some other table in the updateStatement filed in the JDBC Sender Channel Configuration scenario.

And can we have the statements like this,

queryStatement: SELECT * FROM C_BIV_INVENTORY WHERE Exists (SELECT * FROM C_BH_FILTER WHERE INTERFACE = 'BW_BATCH' AND STATUS = 'PENDING')

updateStatement: UPDATE C_BH_FILTER SET STATUS = 'COMPLETE' WHERE INTERFACE = 'BW_BATCH'

Can you please help me out in testing this queries on Oracla database.

Thanks

Soorya.