Archives of the TeradataForum

Message Posted: Fri, 26 Jul 2002 @ 14:33:41 GMT

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

We had this same problem a couple of releases back (about 2 years) and changed our primary index from decimal(18,0) to decimal(15,0). As far as I know the problem was fixed (we did some testing) but we never went back to decimal(18,0). If I remember correctly we received erratic results with the larger numbers but the smaller numbers were OK. We found the problem because we were plugging the highest digit with a value to group id generation.

You might try using a 15 digit decimal with leading 0's as an index value and see if it works as expected.

Jim

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