CREATE COLUMN TABLE "SBODEMODE"."ARTS" ("RateDate" LONGDATE CS_LONGDATE NOT NULL , "Currency" NVARCHAR(3) NOT NULL , "Rate" DECIMAL(21,6) CS_FIXED, "DataSource" NVARCHAR(1) DEFAULT 'N', "UserSign" SMALLINT CS_INT, "ReportType" NVARCHAR(1) DEFAULT 'S' NOT NULL , "LogInstanc" INTEGER CS_INT DEFAULT 0 NOT NULL , "UpdateDate" LONGDATE CS_LONGDATE, "UserSign2" INTEGER CS_INT, PRIMARY KEY ("RateDate", "Currency", "ReportType", "LogInstanc")) UNLOAD PRIORITY 5  AUTO MERGE ;
ALTER TABLE "SBODEMODE"."ARTS" WITH PARAMETERS ('CONCAT_ATTRIBUTE'=('$RateDate$LogInstanc$','RateDate','LogInstanc'));
CREATE INDEX "ARTS_DATE" ON "SBODEMODE"."ARTS" ( "RateDate" ASC, "LogInstanc" ASC )