PL/I · DB2 SQLCODE

SQLCODE -929: Failure in a Data Capture Exit

What does SQLCODE -929: Failure in a Data Capture Exit mean in PL/I?

A table the PL/I program is inserting, updating, or deleting against is defined with DATA CAPTURE CHANGES for replication, and the capture exit reported a failure while processing the change.

SQLCODE -929: Failure in a Data Capture ExitDB2 for z/OS · PL/I (embedded SQL)

Condition

A table the PL/I program is inserting, updating, or deleting against is defined with DATA CAPTURE CHANGES for replication, and the capture exit reported a failure while processing the change.

Fix

Check the token text returned in SQLERRM against the replication/DPROP tooling's own diagnostics — the root cause lives in the capture exit configuration, not the PL/I program itself.

Related db2 sqlcode