select and update statement in jdbc scenario in sap cpi

[former_member669310]

Dear all,

How use select and update statement while picking the records using jdbc receiver adapter in sap cpi, it means initial flag in db table as flag="N", once cpi will read that record flag will become as flag="S".

select and update parameter available in jdbc sender in sap pi, but it would be in sap cpi

Regards,

kranti.

[PiotrRadzki]

Hi Kranti, After you fetch data from DB using JDBC adapter and process it successfully you need to call this DB again with JDBC Receiver adapter (it will be second standalone call to DB) and flag the records as processed using the field flag. For example:

UPDATE <DB_TableName> SET flag = S where flag = N

Such statement need to be placed in Content Modifier. Make sure you only do it when records are processed by CPI to target system or you store it somewhere for processing (JMS or DataStore). It is also important to orchestrate timing of this pull and update depending on how often new records comes in to the DB. This is more specific to your exact scenario.

BR, Piotr

[former_member669310]

Dear Radzki,

Thanks for your inputs,

Select and update statements are working.

Regards,

kranti.

[former_member669310]

Dear Radzki,

I did the same but only select statement working, update statement not working it means flag is not updating.

followed steps as below.

start timer-->select statement in content modifier1-->request replay-->jdbc receiver

update statement in content modifier2-->request replay-->jdbc receiver

both are with in one integration process.

but how both comes under single process.

kindly suggest.

Regards,

kranti.

[former_member669310]

Dear Radzki,

Thank you for your reply.

Regards,

kranti.