![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Wed, 17 Jul 2002 @ 13:46:29 GMT
Subj: | | Re: Queryman and Decimal(10,0) |
|
From: | | Geoffrey Rommel |
| I have a table (see below) | |
CREATE SET TABLE PGS ,NO FALLBACK ,
...
Gallons DECIMAL(10,0) TITLE 'Gallons',
| which when selecting rows from this table returns a '***' for the Gallons (for every single row). | |
Dara, this is a known bug in the ODBC 3.00 driver. It affects any decimal field with a scale of 0 (i.e. 0 positions after the
decimal place). We have recently received a new driver that is supposed to fix this problem, but I haven't tested it yet.
--wgr
| |