Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 26 Feb 2000 @ 14:05:30 GMT


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


Subj:   ODBC driver doesn't use 'format' attribute
 
From:   Mark Landry

Has anyone else seen this problem?

Teradata ODBC Driver for NT does not use 'format' attribute. Binding FLOAT as either SQL_C_CHAR or SQL_C_DEFAULT does not apply database format attribute for the column.

Example:

      BTEQ -- Enter your DBC/SQL request or BTEQ command:
     create table T (a float format 'Z(14).');

      *** Table has been created.

      BTEQ -- Enter your DBC/SQL request or BTEQ command:
     insert T values (35325335961889.);

      *** Insert completed. One row added.
      *** Total elapsed time was 1 second.

      BTEQ -- Enter your DBC/SQL request or BTEQ command:
     select * from T;

      *** Query completed. One row found. One column returned.
      *** Total elapsed time was 1 second.

                   a
     ---------------
     35325335961889.

Using Microsoft's ODBC Admin Demo Application:

     select * from T

OBDC output:

     3.53253e+013

(this should be 35325335961889.)



     
  <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: 15 Jun 2023