CREATE COLUMN TABLE "IMCYC"."OCFP" ("ID" INTEGER CS_INT NOT NULL , "Code" NVARCHAR(6) NOT NULL , "Descrip" NCLOB MEMORY THRESHOLD 1000, "App" NCLOB MEMORY THRESHOLD 1000, "Locked" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "DataSource" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "UserSign" NVARCHAR(6), "LogInstanc" INTEGER CS_INT, "UserSign2" SMALLINT CS_INT, "UpdateDate" LONGDATE CS_LONGDATE, PRIMARY KEY ("ID")) UNLOAD PRIORITY 5  AUTO MERGE ;
CREATE UNIQUE INDEX "OCFP_CFOP_CODE" ON "IMCYC"."OCFP" ( "Code" ASC )