UPDATE_INSERT statement in JDBC receiver

[former_member669310]

Hi,

how to use update_insert statement in jdbc receiver in sap cpi.

Regards,

kranti.

[former_member669310]

Dear Priyanka,

Thank you for your prompt reply.

I have tried the same but not working.

Regards,

Kranti.

[PriyankaChak]

Hi,

The structure is similar to PO.

<StatementName> <dbTableName action="UPDATE_INSERT"> <table>realDbTableName</table> <access> <col1>val1</col1> <col2>val2new</col2> </access> <key1> <col2>val2old</col2> <col4>val4</col4> </key1> <key2> <col2>val2old2</col2> </key2> </dbTableName> </StatementName>

You can refer to the below one: https://sapzero2hero.com/2022/04/15/sap-cpi-update-database-sql-using-jdbc-adapter-via-store-procedu...

Regards,

Priyanka