Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Column constraints
 
From:   Tijoriwalla,Prashant

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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019