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
Decimal getting stored as Junk value in Sequential file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.