Can you share the session log in verbose mode by passing one or two records so that we can check on the issue.
May I suggest that you move this question to the PowerExchange forum (not PowerExchange Adapters!), there you will find the right expert for this kind of question.
OK, well, some concepts first.
"NULL" is a database/SQL concept, not a flat file concept.
(In DB2, it is a flag that gets tagged to a column and tells whether or not that column exists for that row.)
Some people consider x/00 ("Low values") to be a NULL, but they are confused, and that isn't how programs treat it.
ZONED (PIC 9(n) USAGE IS ZONED DECIMAL) fields can only contain numbers, not spaces.
PIC X(n) can contain hexadecimal values (including x/00 and x/FF).
PIC A(n) can only contain characters and spaces, plus some special characters.
You didn't say how you are reading this file - whether through PWX or through something like PowerCenter's "VSAM adapter", and that might change some of how things work.
If you are reading a field as if it were PIC X, then you're going to get pretty whatever is in it.
In some cases, PC can handle that just fine.
In other cases it can't. (X/00 bytes are the classic example.)
If it contains a numeric value, then that's what you'll get.
If you are reading a field as PIC 9, then you're only going to get numeric values.
Anything else will be treated as a data error (unless you're using PWX and have that field flagged for data checking in the data map, in which case it will be assigned a default value.)
Thanks a lot for the detailed explanation.
The field is defined as PIC S9(3)V9(2) at copy book level and we are reading it through PWX datamap and the field is defined as ZONED(3,2) at datamap level.
We have a requirement to check if the field is NULL then exclude the field from the calculations. we were testing by masking it to null in the mainframe source file, but it was getting loaded as 0.00.
Tried nullable option for this field at PWX datamap but it did not work.
It can't be NULL.
That's not an option in a mainframe file.
Do you mean that it was set to LowValues, x/00 ?