Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 30 Dec 2003 @ 08:01:17 GMT


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


Subj:   Re: Identity Column Crisis
 
From:   Prasath Krishna B.K.

Identity column value generated need not be in sequence. It depends on the Batchsize that you have declared in your DBS Control GDO. Here I guess the value declared should be 100000 and so it works as

1st amp is assigned nos from 1 to 100000 incremented by 1
2nd amp is assigned nos from 100001 to 200000 incremented by 1.
And so on..


So if you want the numbers to be strictly sequential then change the batchsize to 1.

Hope this helps.


Regards,

Prasath.



     
  <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