Moving data from mainframe to *nix boxes

Discuss about QA in Mainframe, Back-End Test, Offline code testing and Testing Tools
v1gnesh
Posts: 72
Joined: Wed Sep 28, 2011 8:24 pm
Skillset: boyo
Referer: google

Re: Moving data from mainframe to *nix boxes

Postby v1gnesh » Sun Jul 15, 2012 1:30 am

Robert Sample wrote:It doesn't matter if your client does this or you do this -- but if you want the data to be valid and usable on the *nix machine, SOMEBODY has to convert the packed decimal data.


Thanks. I just mentioned it so that the information is complete.

I'll look up the DFSORT manuals on how to convert packed to zoned data.
boyo

User avatar
dick scherrer
Global moderator
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am

Re: Moving data from mainframe to *nix boxes

Postby dick scherrer » Sun Jul 15, 2012 4:41 am

Hello,

To get you started, use something like the following with your specifics as well as all of your other fields.

(1,8,PD,TO=ZD,LENGTH=16)

The PD,TO=ZD is what you need to read about.
Hope this helps,
d.sch.

v1gnesh
Posts: 72
Joined: Wed Sep 28, 2011 8:24 pm
Skillset: boyo
Referer: google

Re: Moving data from mainframe to *nix boxes

Postby v1gnesh » Sun Jul 15, 2012 5:19 am

dick scherrer wrote:Hello,

To get you started, use something like the following with your specifics as well as all of your other fields.

(1,8,PD,TO=ZD,LENGTH=16)

The PD,TO=ZD is what you need to read about.



Thank you. Very much. I'll look it up and try it out on Monday and let you know how it goes.
boyo

User avatar
dick scherrer
Global moderator
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am

Re: Moving data from mainframe to *nix boxes

Postby dick scherrer » Sun Jul 15, 2012 5:56 am

You're welcome - Good Luck - someone will be here if there are questions :)

d

BillyBoyo
Global moderator
Posts: 3805
Joined: Tue Jan 25, 2011 12:02 am
Skillset: Easytrieve Plus, Cobol, Utilities, that sort of stuff
Referer: Google

Re: Moving data from mainframe to *nix boxes

Postby BillyBoyo » Sun Jul 15, 2012 5:57 am

Look at the DEFSORT manuals for EDIT. Will allow you to explicitly sign and include a decimal point, where necessary.

DFSORT can also do "field level" conversions of EBCDIC to ASCII if that is any use to you.

User avatar
dick scherrer
Global moderator
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am

Re: Moving data from mainframe to *nix boxes

Postby dick scherrer » Sun Jul 15, 2012 6:23 am

Hello,

DFSORT can also do "field level" conversions of EBCDIC to ASCII if that is any use to you.
I believe sending the entire file as "text" will be considerably easier to implement. Then there would be nothing to do but "use" it on the target. The entire text file would be automatically converted from ebcdic to ascii as part of the transfer with nothing else needed. JustMHO . . . 8-)
Hope this helps,
d.sch.

v1gnesh
Posts: 72
Joined: Wed Sep 28, 2011 8:24 pm
Skillset: boyo
Referer: google

Re: Moving data from mainframe to *nix boxes

Postby v1gnesh » Sun Jul 15, 2012 6:39 am

Thanks BillyBoyo. I have worked zero times with DFSORT. It looks like a fun tool that can get a lot done. Will have to learn some basics.

Note to self : Posting this here so I can refer to it later.
dfsort-icetool-icegener/topic3987.html
boyo


  • Similar Topics
    Replies
    Views
    Last post