CREATE COLUMN TABLE "IMCYC"."OOCC" ("AbsEntry" INTEGER CS_INT NOT NULL , "Code" NVARCHAR(10) NOT NULL , "Dscription" NVARCHAR(128), "Note" NVARCHAR(50), "ReqBoeSt" CHAR(1) CS_FIXEDSTRING, "IsMovement" CHAR(1) CS_FIXEDSTRING DEFAULT 'N' NOT NULL , PRIMARY KEY ("AbsEntry")) UNLOAD PRIORITY 5  AUTO MERGE ;
ALTER TABLE "IMCYC"."OOCC" WITH PARAMETERS ('CONCAT_ATTRIBUTE'=('ALLOW_NULL_AS_COMPONENT=YES', '$uc_OOCC_CODE$','Code','IsMovement'));
CREATE UNIQUE INDEX "OOCC_CODE" ON "IMCYC"."OOCC" ( "Code" ASC, "IsMovement" ASC )