CREATE COLUMN TABLE "IMCYC"."OHPS" ("posID" INTEGER CS_INT NOT NULL , "name" NVARCHAR(20) NOT NULL , "descriptio" NCLOB MEMORY THRESHOLD 1000, "LocFields" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', PRIMARY KEY ("posID")) UNLOAD PRIORITY 5  AUTO MERGE ;
CREATE UNIQUE INDEX "OHPS_NAME" ON "IMCYC"."OHPS" ( "name" ASC )