Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Fri, 26 Jul 2002 @ 18:22:23 GMT


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


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

  I'm concerned that you may not have grasped the implications of the previous responses.  



You're right -- I hadn't noticed that subtlety. But in any event it's not an ODBC problem as others had suggested:

SQLExecDirect:
    In:    Statementhandle = 0x008219D8,
          StatementText = "select * from Table_AAA", Statementlength = 23
    Return: SQL_SUCCESS=0

Get Data All:
"Key_col1", "ADate_col2", "AChar_col3", "Another_Dec_col4"
333333333333333505, "2002-07-28", "DDDD ", 400
214555555555567800, "2002-07-25", "BBBB ", 200
104230608995498370, "2002-07-24", "AAAA ", 100
333333333333333500, "2002-07-26", "CCCC ", 300
4 rows 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