Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 09 Apr 2008 @ 12:32:36 GMT


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


Subj:   Identity Column with DEFAULT option on a UPI
 
From:   Anomy Anom

<-- Anonymously Posted: Wed, 9 Apr 2008 16:44 -->

Hello,

I have an IDENTITY column as below,

     CREATE SET TABLE dbtest.test, NO FALLBACK ,
           NO BEFORE JOURNAL,
           NO AFTER JOURNAL,
           CHECKSUM = DEFAULT
           (
            P_ID INTEGER GENERATED BY DEFAULT AS IDENTITY
                      (START WITH 2
                       INCREMENT BY 1
                       MINVALUE 2
                       MAXVALUE 99999999
                       NO CYCLE),
            P_NAME VARCHAR(40) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL)

            UNIQUE PRIMARY INDEX ( P_ID);

This is what I do in steps,

1. This table is empty initially

2. I first insert USER values (Which don't have duplicates) into the column P_ID.

3. In the next insert, when I try to supply NULLs to the column (intented to generate keys), I get Duplicate Primary Key error. This problem is random, doesn't happen always.


Can someone throw some light, on what could be the issue ?


Thanks Lot



     
  <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: 15 Jun 2023