CREATE COLUMN TABLE "IMCYC"."OPQW" ("AbsEntry" INTEGER CS_INT NOT NULL , "SetName" NVARCHAR(20) NOT NULL , "SetDesc" NVARCHAR(100), "CreateDate" LONGDATE CS_LONGDATE, "ModifyDate" LONGDATE CS_LONGDATE, "UserSign" SMALLINT CS_INT, "CreatDraft" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "GroupBy" CHAR(1) CS_FIXEDSTRING DEFAULT 'B', "ValidUntil" LONGDATE CS_LONGDATE, "BPLId" INTEGER CS_INT, "ReqDate" LONGDATE CS_LONGDATE, "BaseOn" CHAR(1) CS_FIXEDSTRING, PRIMARY KEY ("AbsEntry")) UNLOAD PRIORITY 5  AUTO MERGE ;
CREATE UNIQUE INDEX "OPQW_SET_NAME" ON "IMCYC"."OPQW" ( "SetName" ASC )