CREATE COLUMN TABLE "IMCYC"."OALR" ("Code" INTEGER CS_INT NOT NULL , "Type" CHAR(1) CS_FIXEDSTRING DEFAULT 'A', "Priority" CHAR(1) CS_FIXEDSTRING DEFAULT '1', "TCode" INTEGER CS_INT, "Subject" NVARCHAR(254), "UserText" NCLOB MEMORY THRESHOLD 1000, "DataCols" INTEGER CS_INT, "DataParams" NCLOB MEMORY THRESHOLD 1000, "MsgData" NCLOB MEMORY THRESHOLD 1000, "UserSign" SMALLINT CS_INT, "Attachment" NCLOB MEMORY THRESHOLD 1000, "DataSource" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "AtcEntry" INTEGER CS_INT, "AltType" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', PRIMARY KEY ("Code")) UNLOAD PRIORITY 5  AUTO MERGE ;
CREATE INDEX "OALR_USER" ON "IMCYC"."OALR" ( "UserSign" ASC )