Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
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.

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