Problem Reading packed data from ebcdic files

Moderators: chulett, rschirm

Post Reply
r.bhatia
Participant
Posts: 11
Joined: Mon Jun 30, 2008 12:45 am
Location: Manchester

Problem Reading packed data from ebcdic files

Post by r.bhatia »

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
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Poor choice of stage type. Use Complex Flat File stage. It handles packed decimal data much better.

Moderator: please move to Parallel forum
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply