A -713 SQL error occurs when executing a DDL file generated by the analysis of an
RC/Migrator for Db2 for z/OS (RCM) strategy.
The problem occurs after an upgrade to the Db2 Function Level.
SET CURRENT APPLICATION COMPATIBILITY = 'V12R1M505';
DSNT408I SQLCODE = -713, ERROR: THE REPLACEMENT VALUE FOR CURRENT
APPLICATION COMPATIBILITY IS INVALID
DSNT418I SQLSTATE = 42815 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXOSPR SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -100 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFF9C' X'00000000' X'00000000'
X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC
The Post Install upgrade tasks have been completed, including updating the SSIDVERF and SSIDVERC
parameters in the SETUPxx Parmlib member and executing the Bind task.
Release : 20.0
Component : RCM
The -713 error is a result of not performing the post upgrade tasks in the correct order.
The update to the SETUPxx member within hlq.CDBAPARM must be completed before the Post Install Bind task is executed.
Update the SSIDVERF and SSIDVERC parameters in the SETUPxx member and then rerun the Bind task.
Refer to the Upgrade to new Db2 Release and Function Levels documentation.