Archives of the TeradataForum

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

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

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>>