Archives of the TeradataForum

Message Posted: Tue, 12 Jul 2005 @ 09:47:50 GMT

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

<-- Anonymously Posted: Tuesday, July 12, 2005 04:00 -->

     Create table xyz (balance FLOAT FORMAT 'ZZZZZZZZZZZ9.999999999');

     INS INTO DB.xyz values (60.999);
     INS INTO DB.xyz values (50.88);

     Answer Set in Queryman (Implicit conversion)

     Balance
     51
     61

     Answer Set in BTEQ

     sel balance from DB.xyz;
      *** Failure 2621 Bad character in format or data of xyz.balance.
                     Statement# 1, Info =0
      *** Total elapsed time was 1 second.


     sel balance (format 'zzzzzzzzzzz9.999999999') from DB.xyz;
      *** Failure 2621 Bad character in format or data of xyz.balance.
                     Statement# 1, Info =0
      *** Total elapsed time was 1 second.

     sel balance (format 'zzzzzzzzzzz9.99999999') from DB.xyz;

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

                   balance
     ---------------------
               50.88000000
               60.99900000

QUESTIONS:

What is the need to put a FORMAT clause inside a DDL?

Understand that there is an implicit conversion within Queryman. But why does Queryman disregard the FORMAT clause inside the DDL?

Why does BTEQ fail the first time when we had 9 decimal places but succeeds when there are 8 decimal places in the FORMAT column?

Thanks in Advance.

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