Archives of the TeradataForum
Message Posted: Fri, 26 Jul 2002 @ 09:03:25 GMT
We have a similar ID field which is DECIMAL(18,0) and this is also a bit dodgy in Queryman. Basically, if you Select it straight from the table, Queryman will do some wierd rounding on the number, consequently, if you copy and paste this number into another query you will get unexpected results. If you want to see it "as it is", then try casting it into a CHAR(20).
This only affects the value of the number displayed not the value 'inside' the SQL. i.e. if you do something like;
SELECT * FROM BBB WHERE BBB.ID_NUM IN (SELECT AAA.ID_NUM FROM AAA);
That will still give you expected results.
Did you copy the '333333333333333500' out of a Queryman answerset? If so, you may find that this record doesn't exist and the actual number is something like '333333333333333521'
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|