Archives of the TeradataForum

Message Posted: Thu, 12 Apr 2007 @ 14:14:05 GMT

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

Not sure about the jdbc, but for SQL go to Tools>Options>AnswerSet tab and you should see a box for "Display full accuracy for Decimal(16) and above". Make sure this box is checked and you should get the correct number. Also note, that in BTEQ the answer set comes back as:

                       a
     -------------------
     222222333333444444.

This indicates to me that the decimal is being converted to possibly hex or something in jdbc and odbc (unless you do the above for SQL Assistant)

KRT

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