ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

RC/Migrator DSNT408I SQLCODE = -190 Altering an Identity column

book

Article ID: 238592

calendar_today

Updated On:

Products

RC/Migrator for DB2 for z/OS

Issue/Introduction

 In RC/Migrator, altering an Identity column from INT to BIGINT, generated an ALTER and failed on execution with an

SQLCODE -190. 

 ALTER   TABLE USER.MYTABLE                               

    ALTER                                                          

      COLUMN IDENTCOL                              

             SET DATA TYPE BIGINT                                  

            ;                                                      

 DSNT408I SQLCODE = -190, ERROR:  THE ATTRIBUTES SPECIFIED FOR THE 

          COLUMN IDENTCOL ARE NOT COMPATIBLE WITH THE EXISTING COL

          DEFINITION                                                

 DSNT418I SQLSTATE   = 42837 SQLSTATE RETURN CODE                  

 DSNT415I SQLERRP    = DSNXIALC SQL PROCEDURE DETECTING ERROR      

 DSNT416I SQLERRD    = 130  0  0  -1  0  0 SQL DIAGNOSTIC INFORMATIO

DSNT416I SQLERRD    = X'00000082'  X'00000000'  X'00000000'       

          X'FFFFFFFF'  X'00000000'  X'00000000' SQL DIAGNOSTIC     

          INFORMATION                                              

 BPA0012E: DB2 SQL/DDL ERROR HAS OCCURRED - ROLLBACK ISSUED.       

RETCODE =     8 

 

 

Environment

Release : 20.0

Component : RC/Migrator for DB2 for z/OS

Resolution

RC/Migrator should not have generated an ALTER, as the the SQLCODE indicates. A Drop/Create is needed.  In addition due to DDL_Materialization parameter enhancements there are PTF's that must

be applied to ensure the correct DDL generation:

LU04149

LU04150

LU04151

Detail on the -190:

IBM doc:
-190 THE ATTRIBUTES SPECIFIED FOR
THE COLUMN table-name.columnname ARE NOT COMPATIBLE WITH THE EXISTING COLUMN
DEFINITION
Explanation
The attributes for the column in an ALTER TABLE statement are not 
compatible with the attributes of the existing column.
table-name The name of the table.
column-name The name of the column.

Possible reasons for this error include:
Incompatible data type
The ALTER TABLE ALTER COLUMN SET DATA
TYPE statement allows changing columns of the
following data types only:
  • Character
  • Numeric
  • Binary
If the SET DATA TYPE clause was specified, the
existing column is not compatible with the new
data type that was specified, or is of a data type
that cannot be change