Problem Reading packed data from ebcdic files
Posted: Sun Feb 22, 2009 6:11 pm
Hi!
I am using a sequential stage with schema file to read ebcdic data from file
The schema structure is_ as below
record
{record_format={type=implicit}, delim=none, quote=none, binary, ebcdic, native_endian, round=round_inf, fix_zero}
(
BAL_FIELD:nullable decimal[3,0] {default='NULL',zoned};
.......
.......
The balance the record is as follows(hex from mainframe)
0138000170000000000007620Q
FFFFFFFFFFFFFFFFFFFFFFFFFD
01380001700000000000076208
The value in dataset created is 762.01 which is 7p less than actual.
All balance fields that are supposed to have 7,8,9 in last decimal place are reduced to 0,1,2 respectively.
I have no clue on why this is going wrong. Is there something I am missing? Please help
I am using a sequential stage with schema file to read ebcdic data from file
The schema structure is_ as below
record
{record_format={type=implicit}, delim=none, quote=none, binary, ebcdic, native_endian, round=round_inf, fix_zero}
(
BAL_FIELD:nullable decimal[3,0] {default='NULL',zoned};
.......
.......
The balance the record is as follows(hex from mainframe)
0138000170000000000007620Q
FFFFFFFFFFFFFFFFFFFFFFFFFD
01380001700000000000076208
The value in dataset created is 762.01 which is 7p less than actual.
All balance fields that are supposed to have 7,8,9 in last decimal place are reduced to 0,1,2 respectively.
I have no clue on why this is going wrong. Is there something I am missing? Please help