Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 29 Aug 2005 @ 09:50:26 GMT


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


Subj:   Problem with with Decimal field in Fast Export
 
From:   kumar28

Hi,

I am running a fast export to generate a datafile. I am doing a SUM in the field. The field is defined as decimal(9,4) in the table and is nullable.

My fast export is given below. I am passing each record as a character field to avoid any unwanted binary data as a part of my record.

     SELECT
     Sum(zeroifnull(field1))
     (CHAR(20))
     FROM
     Table1
     WHERE
     field2 = '123'
     Group By field3;

The problem is: it is generating the answer set something like below. I am expecting a number instead of the asterisks ********. Please advice.

     ***********
        125.0000
        327.5000
       3239.5000
        255.0000
      64033.0000
         10.0000
     ***********

I have tried casting to a character field but it changes the result to:

     1.85460621446000E 007
     1.25000000000000E 002
     3.27500000000000E 002
     3.23950000000000E 003
     2.55000000000000E 002
     6.40330000000000E 004
     1.00000000000000E 001
     1.58390321284000E 008

I will really appreciate any help to fix this issue.....

Raj



     
  <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