How to read the below amount values using schema file.
Sample values:
-02.50
03.50
At present we using below entry
commission: decimal[5,2] {zoned, width=5};
But I am getting invalid number while reading 2nd value.
Please help me to solve this issue.
Schema file.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can not read them with a schema file; you can only describe them with a schema file. I presume you are using a Sequential File stage. Is the format fixed-width fields (which you don't actually have) or delimited? Or is there only one field. Try reading the field as a VarChar data type (string[max=6] perhaps).
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.