-
Título
Invalid specification message noting issue with charater data length when specifying system defau -
Descrição
When trying to create or alter a table Toad gives the message:
"Invalid Specification - When specifying a system default value of SESSION USER, the datatype column for column CRETD_BY_ID must support character data with a minimum length of 128. "
or
DB2:4/13/2010 3:31:17 PM: 20114: [IBM][DB2/NT] SQL20114W Column "CRETD_BY_ID" in table "DB2ADMIN.DUMMY_CASEY" is not long enough for the defined length of the USER default value. SQLSTATE=01642,These are encountered when trying to run the create script in editor, or when accessing the SQL Script tab from right click in Object Explorer | Alter Table.Table script sample:
CREATE TABLE "DUMMY" (
"DUMMY_ID" INTEGER NOT NULL GENERATED BY DEFAULT
AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20,
NO MINVALUE, NO MAXVALUE, NO CYCLE, NO ORDER),
"CRETD_BY_ID" VARCHAR(8) DEFAULT USER,
"CRETD_BY_TS" TIMESTAMP DEFAULT ,
"MDFYD_BY_ID" VARCHAR(8),
"MDFYD_BY_TS" TIMESTAMP
) -
Causa
This error on any version of DB2...8.2, 9.5, 9.7 etc. on Toad for DB2. Changes on newer versions of DB2 require character data length of minimum 128.
-
Resolução
WORKAROUND:
Alter the table/column to length 128 or more.
-
ID do defeito
ST73043