Start of change

-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

End of change