Page 2 of 2

Re: Moving data from mainframe to *nix boxes

PostPosted: Sun Jul 15, 2012 1:30 am
by v1gnesh
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.

Re: Moving data from mainframe to *nix boxes

PostPosted: Sun Jul 15, 2012 4:41 am
by dick scherrer
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.

Re: Moving data from mainframe to *nix boxes

PostPosted: Sun Jul 15, 2012 5:19 am
by v1gnesh
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.

Re: Moving data from mainframe to *nix boxes

PostPosted: Sun Jul 15, 2012 5:56 am
by dick scherrer
You're welcome - Good Luck - someone will be here if there are questions :)

d

Re: Moving data from mainframe to *nix boxes

PostPosted: Sun Jul 15, 2012 5:57 am
by BillyBoyo
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.

Re: Moving data from mainframe to *nix boxes

PostPosted: Sun Jul 15, 2012 6:23 am
by dick scherrer
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-)

Re: Moving data from mainframe to *nix boxes

PostPosted: Sun Jul 15, 2012 6:39 am
by v1gnesh
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