5 Replies Latest reply on Aug 11, 2020 8:57 AM by dan.smith@informatica.com

    Reading null value from a mainframe ZONED datatype field as 0.00

    Geetha San Seasoned Veteran

      HI All,

       

      I have the below question.

       

      one of the field in mainframe file is defined as ZONED(3,2). Even though the value for this field is mocked as Spaces for testing one of the requirement, its being read as 0.000000 instead of null.

       

      I have a requirement or logic that is different when the value for this field is null instead of values on the fields like 1.00 or 0.12. I have changed the datatype to CHAR to handle null/space values for this field. Even then the value is being read as '  .      0'

       

      Could any one help on this?

       

      Thanks