Archives of the TeradataForum

Message Posted: Mon, 04 Oct 2010 @ 19:18:37 GMT

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

You probably fell in old trap. ODBC treats such big numbers as float and looses precision.

If you cast dbqlogtbl.queryid to varchar(20) you will see different values. ( or try the same from bteq).

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