Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 01 May 2006 @ 22:20:19 GMT


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


Subj:   Problem Creating SEQUENCE using Identity column
 
From:   Anomy Anom

<-- Anonymously Posted: Monday, May 01, 2006 17:54 -->

I tried to create a system generated SEQUENCE using identity column and have defined the identity column as.

     ID_COL INTEGER GENERATED ALWAYS AS IDENTITY
          (START WITH 1
           INCREMENT BY 1
           MINVALUE 1
           MAXVALUE 2147483647
           NO CYCLE))

When rows are inserted with a Ins-Sel, the value for ID_COL starts with 1 and goes until, say some 12343 and suddenly the next row value jumps to 6 digit number 100001 and from then on increments by 1. Is this a bug or the system just tries to find a unique value for each row. I understand row_count() would be useful here, but looking for a system generated SEQUENCE.



     
  <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: 27 Dec 2016