How to update two tables in a single call using JDBC Sender adapter

[Former Member]

Hello All,

The scenario is, database entries have to be selected from two tables and at the same time those tables have to be udpated with the flag.

We are using JDBC sender adapter and in Select Query, we are fetching the data by joinin the two tables.

Update Statemtent: We can only update one table using this statement.

Is it possible to update two tables using the Update Statement without using Stored Procedures.

Let me know.

Regards,

Sreenivas.

[Former Member]

Hi Sreenivas,

> Is it possible to update two tables using the Update Statement without using Stored Procedures.

Yes its possible through join statement

Check this links

Regards

Ramesh

[Former Member]

Hi Sreenivas,

Is it possible to update two tables using the Update Statement without using Stored Procedures.

Not possible.

Update two table using receiver JDBC adapter by caling stored procedure and do all ur logic in the stored procedure...

it is beneficial becuase later u can change the stored procedure in case ur requirement changes...

Regds,

Pinangshuk.