-947 THE SQL STATEMENT FAILED BECAUSE IT WILL CHANGE A TABLE DEFINED WITH DATA CAPTURE CHANGES, BUT THE DATA CANNOT BE PROPAGATED

Explanation
 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.

System action
The statement cannot be processed.

System programmer response
 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