SQLCODE -302 when changing the name of the table
search cancel

SQLCODE -302 when changing the name of the table

book

Article ID: 95674

calendar_today

Updated On:

Products

RC Compare for DB2 for z/OS Database Analyzer for DB2 for z/OS Fast Unload for DB2 for z/OS Fast Check for DB2 for z/OS Fast Index for DB2 for z/OS Rapid Reorg for DB2 for z/OS

Issue/Introduction

Using RC/Update and select
Option => "E"
Object => "T"
Item Name => enter a table name which has different creators
Creator => "enter Creator name" 
but while changing the name of the table or the name of the creator it failed by 
********************************* TOP OF DATA ********************************
DSNT408I SQLCODE = -302, ERROR:  THE VALUE OF INPUT VARIABLE OR              
         PARAMETER NUMBER 001 IS INVALID OR TOO LARGE FOR THE TARGET          
         COLUMN OR THE TARGET VALUE                                          
DSNT418I SQLSTATE   = 22001 SQLSTATE RETURN CODE                              
DSNT415I SQLERRP    = DSNXECP SQL PROCEDURE DETECTING ERROR                  
DSNT416I SQLERRD    = -315  0  0  4096  0  0 SQL DIAGNOSTIC INFORMATION      
DSNT416I SQLERRD    = X'FFFFFEC5'  X'00000000'  X'00000000'                  
         X'00001000'  X'00000000'  X'00000000' SQL DIAGNOSTIC                
         INFORMATION                                                          
******************************** BOTTOM OF DATA ******************************

How to get rid of SQLCODE -302 error message in CA Database Management r20?
DSNT408I SQLCODE = -302, ERROR:  THE VALUE OF INPUT VARIABLE OR              
         PARAMETER NUMBER 001 IS INVALID OR TOO LARGE FOR THE TARGET          
         COLUMN OR THE TARGET VALUE        

Environment

CA Database Management r20

Resolution

This problem is described and fixed in r20 PTF SO01415 (r20 INC4) position 56. SQLCODE -302 WHEN CHANGING THE NAME OF THE TABLE.