CREATE COLUMN TABLE "IMCYC"."FAA1" ("Code" INTEGER CS_INT NOT NULL , "LineNum" INTEGER CS_INT NOT NULL , "AttrID" INTEGER CS_INT NOT NULL , "AttrName" NVARCHAR(100), "FieldType" CHAR(1) CS_FIXEDSTRING, "DefaultVal" NVARCHAR(100), "LogInstanc" INTEGER CS_INT DEFAULT 0, "SnapshotId" INTEGER CS_INT DEFAULT 0, PRIMARY KEY INVERTED VALUE ("Code", "LineNum")) UNLOAD PRIORITY 5  AUTO MERGE ;
ALTER TABLE "IMCYC"."FAA1" WITH PARAMETERS ('CONCAT_ATTRIBUTE'=('ALLOW_NULL_AS_COMPONENT=YES', '$uc_FAA1_UNIQUE$','Code','AttrID'));
CREATE UNIQUE INDEX "FAA1_UNIQUE" ON "IMCYC"."FAA1" ( "Code" ASC, "AttrID" ASC )