CREATE COLUMN TABLE "IMCYC"."HMM1" ("DocEntry" INTEGER CS_INT NOT NULL , "LineNum" INTEGER CS_INT NOT NULL , "ViewType" CHAR(1) CS_FIXEDSTRING, "ViewName" NVARCHAR(100) NOT NULL , "MenuDesc" NVARCHAR(254), "MenuEnable" CHAR(1) CS_FIXEDSTRING, "IAEnable" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', PRIMARY KEY INVERTED VALUE ("DocEntry", "LineNum")) UNLOAD PRIORITY 5  AUTO MERGE ;
CREATE UNIQUE INDEX "HMM1_UNIQUEVIEW" ON "IMCYC"."HMM1" ( "ViewName" ASC )