Skip to Content
Former Member
Sep 01, 2006 at 06:26 AM

Sender JDBC adapter


Hi All,

I have 2 tables. First table



Name EmpId Status

Jai 5601 0

Karthik 5579 0



Name Contactnumber

Jai 9894268913

Jai 04312432431

Karthik 98984110335

Karthik 04222643993

Now I need to select a single record from Header and all its corresponding records from Item then I need to update the status field to prevent processing the same record and move to next header and all its corresponding Item records. How can I achieve this in a scenario with out BPM? How should I write my SQL and Update SQL in sender commn channel?

Appreciate your help in this.

Thanks & Regards,

Jai Shankar.