Archives of the TeradataForum

Message Posted: Wed, 09 May 2001 @ 13:37:08 GMT

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

Claybourne is correct; However, I would just use columns separated by a comma and not concatenated together. The effect is the same without converting all of the columns to character first. As long as the columns values in total are Unique then the CSUM will create a unique key id. Be careful of using columns with nulls due to the unknown nature of the value.

Also, you can cast the original number 1 as 1 (decimal(18,0)) this might help you get past the integer limitation if that is close. While CSUM is a little resource intensive, it should be the fastest way of creating this unique key id. You shouldn't have much of a skew problem if the values in the column list are unique. Spool of course is always a problem on your entire largest table in the system. Make sure you have enough.

Good Luck,

Eric

EJK
Eric J. Kohut
Senior Solutions Consultant - Teradata Solutions Group - Retail
Certified Teradata Master
NCR Corp.

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