SOS for long varchar hello.
i have the next for create one table into db2
CREATE TABLE "MYSQUEMA"."TABLADEMO" (
"ID" INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (
START WITH +0
INCREMENT BY +1
MINVALUE +0
MAXVALUE +2147483647
NO CYCLE
NO CACHE
NO ORDER ) ,
"TITULO" VARCHAR(250) ,
"COMENTARIO" LONG VARCHAR,
"IDIOMA" VARCHAR(5) NOT NULL ,
"ESTADO" VARCHAR(50) NOT NULL WITH DEFAULT 'true' )
IN "MISPACIO" ;
the problem is that i must to create one long varchar, or using oher type of
field, with 6000 for the max size.
is this posible? how?
i cannot use clob, blob... field type. |