CREATE COLUMN TABLE "IMCYC"."OCPR" ("CntctCode" INTEGER CS_INT NOT NULL , "CardCode" NVARCHAR(15) NOT NULL , "Name" NVARCHAR(50) NOT NULL , "Position" NVARCHAR(90), "Address" NVARCHAR(100), "Tel1" NVARCHAR(20), "Tel2" NVARCHAR(20), "Cellolar" NVARCHAR(50), "Fax" NVARCHAR(20), "E_MailL" NVARCHAR(100), "Pager" NVARCHAR(30), "Notes1" NVARCHAR(100), "Notes2" NVARCHAR(100), "DataSource" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "UserSign" SMALLINT CS_INT, "Password" NVARCHAR(8), "LogInstanc" INTEGER CS_INT DEFAULT 0, "ObjType" NVARCHAR(20) DEFAULT '11', "BirthPlace" NVARCHAR(100), "BirthDate" LONGDATE CS_LONGDATE, "Gender" CHAR(1) CS_FIXEDSTRING DEFAULT 'E', "Profession" NVARCHAR(50), "updateDate" LONGDATE CS_LONGDATE, "updateTime" INTEGER CS_INT, "Title" NVARCHAR(10), "BirthCity" NVARCHAR(100), "Active" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "FirstName" NVARCHAR(50), "MiddleName" NVARCHAR(50), "LastName" NVARCHAR(50), "BirthState" NVARCHAR(3), "ResidCity" NVARCHAR(100), "ResidCntry" NVARCHAR(100), "ResidState" NVARCHAR(3), "NFeRcpn" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "EmlGrpCode" NVARCHAR(20), "BlockComm" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "FiscalCode" NVARCHAR(16), "CtyPrvsYr" NVARCHAR(100), "SttPrvsYr" NVARCHAR(3), "CtyCdPrvsY" NVARCHAR(4), "CtyCurYr" NVARCHAR(100), "SttCurYr" NVARCHAR(3), "CtyCdCurYr" NVARCHAR(4), "NotResdSch" CHAR(1) CS_FIXEDSTRING, "CtyFsnCode" NVARCHAR(100), PRIMARY KEY ("CntctCode")) UNLOAD PRIORITY 0  AUTO MERGE ;
ALTER TABLE "IMCYC"."OCPR" WITH PARAMETERS ('CONCAT_ATTRIBUTE'=('ALLOW_NULL_AS_COMPONENT=YES', '$uc_OCPR_CARD$','CardCode','Name'));
CREATE UNIQUE INDEX "OCPR_CARD" ON "IMCYC"."OCPR" ( "CardCode" ASC, "Name" ASC )