|  |  | Archives of the TeradataForumMessage Posted: Fri, 26 Jul 2002 @ 18:22:23 GMT
 
 
  
| 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.
 
 |  |