JDBC Recv - Select and Update

[prabhu_s2]

Hi,

With JDBC recv, can we select records with status "10" and update the selected records with status "10" to "20" in the same XML strucutre?

[Former Member · Accepted solution]

Prabhu,

With JDBC recv, can we select records with status "10" and update the selected records with status "10" to "20" in the same XML strucutre?

Yes, you can do that. Go through the SAP Help documents for the required structure. Use "SQL_QUERY" as the action to be performed.

You can use graphical and XSL mapping for this, but I would prefer XSL for the same.

Use Sync send from IP to get the response back.

Regards,

Neetesh