| |
- Causa
- THE SQL STATEMENT FAILED BECAUSE IT WILL CHANGE A TABLE DEFINED WITH DATA CAPTURE CHANGES, BUT THE DATA CANNOT BE PROPAGATED.
The DPROP SUPPORT option on the installation panel is set to 2 (support DPROP only).
The SQL statement would have changed a table defined with DATA CAPTURE CHANGES.
However, the data cannot be propagated because the SQL statement did not originate from an IMS subsystem, or monitor trace class 6 was not active
at the beginning of the unit of work for that change.
- Ação do sistema
- The statement is not executed.
- Resposta ao Desenvolvedor
- Take one of the following actions:
- Change the installation option to 1 (no propagation) or 3 (permit changes from any subsystem).
- Change the application program that receives this SQLCODE so that it can be run in an IMS subsystem, and activate monitor trace class 6.
If the installation option is changed to 3, SQL changes to tables defined with DATA CAPTURE CHANGES are permitted from any subsystem, but they
are not propagated unless the environment is set up for propagation.
SQLSTATE: 56038
© Copyright IBM Corp.
|
| |
