Hi
Can we have index and trigger on TYPEd tables.
Also can we have primary key constraint on such tables. The moment I tried to create the primary key, it says, the column can take null values and if I impose in the TYPE, then it says the following error.
CREATE TYPE "TIPT_TYPE" AS ( "ID" integer NOT NULL, "NAME" VARCHAR(30) , "SYSCAT_TAB" VARCHAR(30), "ITEM_TYPE" VARCHAR(4)) INSTANTIABLE INLINE LENGTH 132 WITHOUT COMPARISONS NOT FINAL REF USING INTEGER MODE DB2SQL
DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "NULL" was found following "S ( "ID" integer NOT". Expected tokens may include: "COMPACT". SQLSTATE=42601
If so, can you pls give the syntax [pls don't say 'search in google']
Thanks
Can we have index and trigger on TYPEd tables.
Also can we have primary key constraint on such tables. The moment I tried to create the primary key, it says, the column can take null values and if I impose in the TYPE, then it says the following error.
CREATE TYPE "TIPT_TYPE" AS ( "ID" integer NOT NULL, "NAME" VARCHAR(30) , "SYSCAT_TAB" VARCHAR(30), "ITEM_TYPE" VARCHAR(4)) INSTANTIABLE INLINE LENGTH 132 WITHOUT COMPARISONS NOT FINAL REF USING INTEGER MODE DB2SQL
DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "NULL" was found following "S ( "ID" integer NOT". Expected tokens may include: "COMPACT". SQLSTATE=42601
If so, can you pls give the syntax [pls don't say 'search in google']
Thanks
