CREATE COLUMN TABLE "SBODEMOPT"."HEM7" ("empID" INTEGER CS_INT NOT NULL , "line" SMALLINT CS_INT NOT NULL , "ConName" NVARCHAR(50), "PmntNotes" NVARCHAR(50), "AN" DECIMAL(21,6) CS_FIXED, "AG" DECIMAL(21,6) CS_FIXED, "BankName" NVARCHAR(50), "BankCode" NVARCHAR(20), "BankAcct" NVARCHAR(20), "LogInstanc" INTEGER CS_INT DEFAULT 0, "ANCurrency" NVARCHAR(3), "AGCurrency" NVARCHAR(3), "Sequence" NVARCHAR(1) DEFAULT 'M', "EnBnkAcct" NCLOB MEMORY THRESHOLD 1000, "EncryptIV" NVARCHAR(100), PRIMARY KEY ("empID", "line")) UNLOAD PRIORITY 5  AUTO MERGE 