80 byte file without layout - convert PD to ZD



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

80 byte file without layout - convert PD to ZD

Postby ranga_subham » Sat May 16, 2009 10:07 pm

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:
ranga_subham
 
Posts: 279
Joined: Fri Jul 18, 2008 7:46 pm
Has thanked: 0 time
Been thanked: 1 time

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

 

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

Postby dick scherrer » Sun May 17, 2009 5:05 am

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

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

Postby ranga_subham » Sun May 17, 2009 7:05 pm

Hi,

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

Thanks.
ranga_subham
 
Posts: 279
Joined: Fri Jul 18, 2008 7:46 pm
Has thanked: 0 time
Been thanked: 1 time

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

Postby dick scherrer » Sun May 17, 2009 10:01 pm

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 :)
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

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

Postby ranga_subham » Mon May 18, 2009 10:23 am

Ok. Thanks.
ranga_subham
 
Posts: 279
Joined: Fri Jul 18, 2008 7:46 pm
Has thanked: 0 time
Been thanked: 1 time


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post