Archives of the TeradataForum

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

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

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>>