CREATE COLUMN TABLE "IMCYC"."AHE1" ("empID" INTEGER CS_INT NOT NULL , "line" SMALLINT CS_INT NOT NULL , "fromDate" LONGDATE CS_LONGDATE, "toDate" LONGDATE CS_LONGDATE, "reason" NVARCHAR(20), "approvedBy" NVARCHAR(20), "cnfrmrNum" INTEGER CS_INT, "LogInstanc" INTEGER CS_INT DEFAULT 0 NOT NULL , "type" INTEGER CS_INT, PRIMARY KEY INVERTED VALUE ("empID", "line", "LogInstanc")) UNLOAD PRIORITY 5  AUTO MERGE 