populating JDBC table based on content

[mohammadaamir_khan]

Hi All,

I have SOAP to JDBC scenario. Based on value in message, i need to populate different tables. Tables are populated using action 'INSERT'.

Please suggest how to achieve this.

Thanks in advance.

[manoj_khavatkopp · Accepted solution]

Hi,

You can create multiple "Statement" structure in Data type, where each Statment refers to the structure of an individual table. Then you can have a condition using createIf for this individual statement based on source field value.

Br,

Manoj

[former_member190293]

Hi Mohammad!

Agree with Manoj.

Another option would be to use dynamic SQL statement for JDBC message.

Regards, Evgeniy.