|  |  | Archives of the TeradataForumMessage Posted: Wed, 14 Sep 2005 @ 17:45:57 GMT
 
 
  
| Subj: |  | Re: Problems loading Decimal(18) |  |  |  | From: |  | Hassinger, Bill |  
 Fred Pluebell wrote: |  | Are you loading / querying via ODBC? The fixed precision numeric definition for ODBC only supports up to 15 decimal digits. You can use a
CLI-based load / query tool (e.g. BTEQ) or you can use CHAR/VARCHAR fields externally and CAST them on the database side: |  | 
 
 
 This reply reminded my that there is a checkbox under Options -> Answerset for displaying accuracy over 15 digits. 
 
 |  |