-4756 INVALID COMBINATION OF REPLICATION OVERRIDES IN EFFECT WHEN A DATA CHANGE OPERATION IS ATTEMPTED
Explanation
A data change operation was specified for a system-period temporal table and an invalid combination of replication overrides are in effect. The error can be issued for the following operations.An insert or update operation specified a value for a row-begin, row-end,
transaction-start-ID, or a generated expression column, and a replication override setting is not in
effect for the application compatibility level.
- For an application that is run with application compatibility 502 (or lower), the SYSPROC.SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY stored procedure was not invoked before the data change operation and the SYSIBMADM.REPLICATION_OVERRIDE built-in global variable is set to 'Y'. This combination is not supported.
- For an application that is run with application compatibility 503 (or higher), the SYSIBMADM.REPLICATION_OVERRIDE built-in global variable is set to 'N' and the SYSPROC.SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY stored procedure has been invoked. This combination is not supported.
A delete operation was specified for a system-period temporal table and an invalid
combination of replication overrides are in effect.
- For an application that is run with application compatibility 502 (or lower), the SYSPROC.SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY stored procedure was not invoked and the SYSIBMADM.REPLICATION_OVERRIDE built-in global variable is set to 'Y'. This combination is not supported.
- For an application that is run with application compatibility 503 (or higher), the SYSIBMADM.REPLICATION_OVERRIDE built-in global variable is 'N' and the SYSPROC.SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY stored procedure has been invoked. This combination is not supported.
System action
The statement cannot be processed.
Programmer response
Change your application in one of the following ways:- Use a valid replication override for the application compatibility level that is in effect
- Run the application at an application compatibility level that is appropriate for the replication override that is used by the application
SQLSTATE
428IC