RC/Migrator DSNT408I SQLCODE = -190 Altering an Identity column
Article ID: 238592
Updated On:
Products
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:
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
Feedback
