View Single Post

   
  #1 (permalink)  
Old 02-27-2008, 05:18 AM
James o'konnor
 
Posts: n/a
Default 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.


Reply With Quote