CREATE COLUMN TABLE "IMCYC"."OFRM" ("AbsEntry" INTEGER CS_INT NOT NULL , "Name" NVARCHAR(100), "Encoding" NVARCHAR(100), "FilePath" NCLOB MEMORY THRESHOLD 1000, "IsSystem" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "FrmatType" CHAR(1) CS_FIXEDSTRING DEFAULT 'O', "FileContnt" BLOB MEMORY THRESHOLD 1000, "FrmatStats" CHAR(1) CS_FIXEDSTRING DEFAULT 'U', "PaymType" CHAR(1) CS_FIXEDSTRING DEFAULT 'X', PRIMARY KEY ("AbsEntry")) UNLOAD PRIORITY 5  AUTO MERGE ;
ALTER TABLE "IMCYC"."OFRM" WITH PARAMETERS ('CONCAT_ATTRIBUTE'=('$Name$FrmatType$','Name','FrmatType'));
CREATE INDEX "OFRM_NAME_TYPE" ON "IMCYC"."OFRM" ( "Name" ASC, "FrmatType" ASC )