RC Compare for DB2 for z/OSDatabase Analyzer for DB2 for z/OSFast Unload for DB2 for z/OSFast Check for DB2 for z/OSFast Index for DB2 for z/OSRapid 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.