search cancel

SQLCODE -713 occurs for SET CURRENT APPLICATION COMPATIBILITY

book

Article ID: 214987

calendar_today

Updated On:

Products

RC/Migrator for DB2 for z/OS Database Management for DB2 for z/OS - Administration Suite

Issue/Introduction

A -713 SQL error occurs when executing a DDL file generated by the analysis of an RC/Migrator 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        
         INFORMATION                                                 

The post upgrade tasks have been completed, including updating the SSIDVERF and SSIDVERC parameters in the SETUPxx Parmlib member and executing the Bind task.

 

Cause

The -713 error is a result of not performing the post upgrade tasks in the correct order.

Environment

Release : 20.0

Component : CA RC/Migrator for DB2 for z/OS

Resolution

The update to the SETUPxx member must be completed before the Bind task is executed.

Update the SSIDVERF and SSIDVERC parameters in the SETUPxx member and then rerun the Bind task. 

Additional Information

Refer to the Upgrade to new Db2 Function Levels documentation in Techdocs.