CREATE COLUMN TABLE "IMCYC"."HTM1" ("teamID" INTEGER CS_INT NOT NULL , "line" SMALLINT CS_INT, "empID" INTEGER CS_INT NOT NULL , "role" CHAR(1) CS_FIXEDSTRING DEFAULT 'M', PRIMARY KEY INVERTED VALUE ("teamID", "empID")) UNLOAD PRIORITY 5  AUTO MERGE 