Archives of the TeradataForum
Message Posted: Tue, 30 Dec 2003 @ 08:01:17 GMT
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
So if you want the numbers to be strictly sequential then change the batchsize to 1.
Hope this helps.
|Copyright 2012 - All Rights Reserved|
|Last Modified: 21 Mar 2013|