CREATE COLUMN TABLE "SBODEMODE"."OCPN" ("CpnNo" INTEGER CS_INT NOT NULL , "Name" NVARCHAR(100), "Type" NVARCHAR(1) DEFAULT 'E', "TargetGrp" NVARCHAR(20), "Owner" INTEGER CS_INT, "Status" NVARCHAR(1) DEFAULT 'O', "StartDate" LONGDATE CS_LONGDATE, "FinishDate" LONGDATE CS_LONGDATE, "Remarks" NCLOB MEMORY THRESHOLD 1000, "WizardGen" NVARCHAR(1) DEFAULT 'N', "Template" BLOB MEMORY THRESHOLD 1000, "AtcEntry" INTEGER CS_INT, "Attachment" NCLOB MEMORY THRESHOLD 1000, "LogIns" INTEGER CS_INT, "UserSign2" SMALLINT CS_INT, "UpdateDate" LONGDATE CS_LONGDATE, "UserSign" SMALLINT CS_INT, "CreateDate" LONGDATE CS_LONGDATE, "DataSource" NVARCHAR(1) DEFAULT 'N', "Transfered" NVARCHAR(1) DEFAULT 'N', "Instance" SMALLINT CS_INT DEFAULT 0, "Url" NCLOB MEMORY THRESHOLD 1000, "TmplPath" NVARCHAR(254), "TargetType" NVARCHAR(1) DEFAULT 'C', "ExeOption" NVARCHAR(1) DEFAULT 'O', "Executed" NVARCHAR(1), "VersionNum" NVARCHAR(13), PRIMARY KEY ("CpnNo")) UNLOAD PRIORITY 5  AUTO MERGE 