CREATE COLUMN TABLE "SBODEMOPT"."HEM1" ("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, "type" INTEGER CS_INT, "EncryptIV" NVARCHAR(100), PRIMARY KEY ("empID", "line")) UNLOAD PRIORITY 5  AUTO MERGE 