Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   FORMAT Issue with FLOAT datatype?
 
From:   Anomy Anom

<-- 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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016