received this error message DB21034E running an ALTER Stmt

Question posted by: ccoq (Newbie) on October 7th, 2008 02:00 PM

I received the below error message when I ran this command
ALTER TABLE WAC.SUPPRESSED_CUSTOMER ALTER COLUMN CUSTOMER_ID SET DATA TYPE VARCHAR(28)

DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0190N ALTER TABLE "WAC.SUPPRESSED_CUSTOMER" specified attributes for
column "CUSTOMER_ID" that are not compatible with the existing column.
SQLSTATE=42837

I am trying to change the size of a column on an existing table from 18 to 28.. the describe for the table is below:
db2 => describe select * from wac.suppressed_customer

SQLDA Information

sqldaid : SQLDA sqldabc: 1136 sqln: 20 sqld: 4

Column Information

sqltype sqllen sqlname.data sqlname.length
-------------------- ------ ------------------------------ --------------
452 CHARACTER 18 CUSTOMER_ID 11
392 TIMESTAMP 26 EXPIRY_DATE 11
452 CHARACTER 30 MOD_BY 6
392 TIMESTAMP 26 MOD_DATE 8

Quote | Subscribe