Archives of the TeradataForum

Message Posted: Mon, 28 Jan 2013 @ 12:48:02 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

This seems to be a MULTI SET table, try the inserts again after changing the PI to be non UPI.

     CREATE MULTISET TABLE DEV.tblElig ,NO FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL,
          CHECKSUM = DEFAULT,
          DEFAULT MERGEBLOCKRATIO
          (
           EligValue CHAR(18) CHARACTER SET LATIN CASESPECIFIC,
           EID INTEGER NOT NULL,
           EligCode VARCHAR(2) CHARACTER SET LATIN CASESPECIFIC NOT NULL,
           ModifiedDate DATE FORMAT 'YY/MM/DD' NOT NULL,
           CurrInd BYTEINT,
     CONSTRAINT fk_EID_5 FOREIGN KEY ( EID ,ModifiedDate ) REFERENCES Dev.tblE ( EID , ModifiedDate ),
     CONSTRAINT fk_EligCode_1 FOREIGN KEY (      EligCode ) REFERENCES Dev.lkElig ( EligCode ))
     PRIMARY INDEX PI_tbkElig ( EID ,EligCode ,ModifiedDate );

Prashant Tijoriwalla

	<Prev	Next>		<<First	<Prev	Next>	Last>>