Decimal getting stored as Junk value in Sequential file

[RAJARP]

Hi,
In a parallel job, the target is a seq file with two columns(one char field and one decimal field(4,2))

If i do a 'view data' from the SF stage, I am able to see the data properly.

Char_field|decimal_field
a1234|4356.73

But If i try to open that from unix

cat filename.txt
Char_field|decimal_field
a1234|y5t

And obviously this 'y5t' is not from source.I am not sure how this is happening.

Somebody please help!!!!

Thanks in advance,
Raja R P

[ray.wurlod]

Decimal values are stored in binary. Convert to VarChar if you want to see their text equivalent. You're lucky that the binary representation did not corrupt your stty settings. The data browser effects a conversion.

[asorrell]

And before you ask, you'll need to use the DecimalToString function to do that conversion properly.

[RAJARP]

Thanks Ray and Andy,
It worked.I Used DecimalToString