Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 26 Jul 2002 @ 15:21:57 GMT

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

Subj:   Re: Dec(18,0)
From:   Mark Landry

  If you're running this query from Queryman or any other ODBC > application then I think you'll find it's because of the odbc driver. As a check can you run the same query from Bteq?  

It works fine with Teradata ODBC driver (version

    In:    Statementhandle = 0x00821978,
          StatementText = "Sel * from Table_AAA where Key_col1 = 33333333333...", Statementlength = 56
    Return: SQL_SUCCESS=0

Get Data All:
"Key_col1", "ADate_col2", "AChar_col3", "Another_Dec_col4"
333333333333333500, "2002-07-26", "CCCC ", 300
1 row fetched from 4 columns.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020