Issue with Update statement in JDBC Sender Channel

[Former Member]

Hi Experts,

i am doing JDBC to JDBC scenario, have done with configuration and i am going to test the scenario. its huge data i am sending form sender to receiver it is approx 15k. so i have split the messages, each message have 100 records.i have build a select query and update query  in sender channel to get the records from the DB. in Select query it getting 100 records then executing the update query it should be more than 100 records. so that i am unable to send the 15k records to receiver some records are missing. my queries are

select UID, Perner from table where ROWNUM <=100 and flag IS NULL;

my update query is

Update table set flag = 'Y' where Perner in(select Perner form table where ROWNUM <= 100 and flag IS NULL)

please give me approaches to resolve the issue. highly appreciated your help.

regards,

Sanjay.

[baskar_gopalakrishnan2]

You set default value for the flag is 0.  flag =0 and during update statement set the flag =1. I'm guessing not null where clause cause the problem.

You might want to check these threads

http://scn.sap.com/thread/1595628

http://scn.sap.com/thread/885380

[Former Member]

Hi Sanjay,

In the JDBC Sender Scenario, the Where clause condition in SELECT and UPDATE statement should be same

So just change your update staement as

Update table set flag = 'Y' where ROWNUM <= 100 and flag IS NULL

Regard's

Preethi.

[Former Member]

Hi Preethi,

Thanks for Prompt reply i have tried the same query but it should not work.

regards,

sanjay.