DSXchange

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.

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