Sender JDBC adapter -- Update SQL statement NOT work for the last record

[pansy_leung]

I'm trying to use SAP XI to send records from Oracle database to As/400 using JDBC adapter. I've defined the communication channel for sender

(1) The "Query SQL statement" = select a_bgn_dt, a_end_dt from PX_PXXD WHERE NOT CU_ACTION_CD='P'

(2) The "Update SQL statement" = update PX_PXXD set CU_ACTION_CD='P' WHERE NOT CU_ACTION_CD='P'

Supposed that 3 records were retrieved from (1) and successfully updated to AS/400 but only the first 2 records in Oracle database are updated according to (2)

Any advise.

Pansy

[Former Member]

What is the error in communication channel...

[Former Member]

Hi Pansy,

You select and update query is looking like wrong

kindly check below query,If you are using oracle

(1) The "Query SQL statement" = select a_bgn_dt, a_end_dt from PX_PXXD WHERE CU_ACTION_CD !='P'

(2) The "Update SQL statement" = update PX_PXXD set CU_ACTION_CD='P' WHERE CU_ACTION_CD !='P'

Thank you

Sateesh

[Former Member]

@ Sateesh

You select and update query is looking like wrong

The Select and Update queries are perfectly fine. You can use "NOT" in the query.

@ Pansy

Use logSQLStatement = true in the JDBC channel and check the log.

[Former Member]

That sounds strange. Can you test with the following update statement: "update PX_PXXD set CU_ACTION_CD='P'"