Archives of the TeradataForum

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

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

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