Page 1 of 1

80 byte file without layout - convert PD to ZD

PostPosted: Sat May 16, 2009 10:07 pm
by ranga_subham
Hi, We receive a 80 byte file that contains several PD fields. We don't have copybook for the same to match it with File-Aid to know what value those PD fileds would be having. The customer sends the file and requests us to convert the PD to ZD and download it into xl file and send back the same. The file has a max of 100 records.

Would you please suggest me a way to figure out the lengths of those PD fields and the needed SORT card for the same? :?

Thanks in advance. :roll:

Re: 80 byte file without layout - convert PD to ZD

PostPosted: Sun May 17, 2009 5:05 am
by dick scherrer
Hello,

The customer needs to provide the file layout or at least the order of the fields in the file. If they can create the file, they know what fields are put into the file.

Once the field positions are known, ZD (zoned-decimal) is not the format to use to download to Excel. One of the easiest ways to use mainframe data in Excel is to create a delimited (the tab character (x'05') works well for the delimiter) file with edited numeric fields that will contain the minus sign (if negative) and an actual decimal point.

Re: 80 byte file without layout - convert PD to ZD

PostPosted: Sun May 17, 2009 7:05 pm
by ranga_subham
Hi,

Since the layout is not available, I am using HEX ON to figure out the values !

Thanks.

Re: 80 byte file without layout - convert PD to ZD

PostPosted: Sun May 17, 2009 10:01 pm
by dick scherrer
Hello,

I am using HEX ON to figure out the values
Hopefully, there is only 1 record format and no COMP fields.

Once the layout has been determined, keep in mind that ZD will not work well for input to Excel.

Good luck :)

Re: 80 byte file without layout - convert PD to ZD

PostPosted: Mon May 18, 2009 10:23 am
by ranga_subham
Ok. Thanks.