Archives of the TeradataForum

Message Posted: Mon, 17 Jan 2011 @ 13:14:51 GMT

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

Don't forget that AFTER finding anotehr row with the same row hash the DBMS then checks the data values. Only if the data values are duplicated will the new row be rejected as duplicate PI value. You can get duplicate rowhash values even with a UPI.

Cheers,

Dave

Ward Analytics Ltd: Information in motion (www.ward-analytics.com)

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