Sender JDBC stored procedure

[former_member184619]

Hi,

I am having an requirement to fetch and update records from PO_HEADER and PO_DETAILS field from DB2 database. Also, I need to update the trans_flag from 1 to 2 in both the tables.

DB team is ready to write the stored procedure, but they are asking what should goes into. Also, what would be the structure of result-set, that I'll use for my sender data type, assuming PO_num, Vendor, PO_item, Po_material are the fileds.

Regards,

Sachin Dhingra

[former_member184619 · Accepted solution]

Db guys created a view with a trigger, which will allow to update both tables in one go.

[iaki_vila]

Hi Sachin,

I usually do the next:

1, In the Select box a i set the Select with all the fields and the tables.

2. In the Update box i set the stored procedure. It is very important to have the same Select that the other box and to assure to take the same registers, depending your DB you can control it in different ways. An important matter is to have the tables seriarizables in order to assure the transactional behavior.

Regards.

[dipen_pandya]

Hi,

Please refer this blog if its helpful for your requirement

Regards,

Dipen.