CREATE COLUMN TABLE "IMCYC"."OCOG" ("GroupCode" SMALLINT CS_INT NOT NULL , "GroupName" NVARCHAR(30) NOT NULL , "Commission" DECIMAL(21,6) CS_FIXED, "PrvComsnPr" DECIMAL(21,6) CS_FIXED, "Locked" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "DataSource" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "UserSign" SMALLINT CS_INT, PRIMARY KEY ("GroupCode")) UNLOAD PRIORITY 5  AUTO MERGE ;
CREATE UNIQUE INDEX "OCOG_GROUP_NAME" ON "IMCYC"."OCOG" ( "GroupName" ASC )