Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 04 Apr 2008 @ 21:58:40 GMT


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


Subj:   Re: Identity -- min, max significance
 
From:   Victor Sokovin

  In my test cases , I've been able to insert the records to its limit but the same when done form Java/ JDBC there is a random failure saying "exceeded identity limit " even though there were hardly few records present in the table.  


  Have checked the INS statement generated from java / JDBC, looks like, INS project (all columns except identity) values (.....);  


You might have hit the difference first communicated by Dieter in

www.teradataforum.com/teradata/20040526_183136.htm .

In general, I would not recommend using identity column if you have a very precise set of rules you want the column to comply with. Identity columns were designed to simply generate unique numbers. The numbers are never guaranteed to be sequential.

There many other approaches such as using functions like CSUM.


Victor



     
  <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