Moving data from mainframe to *nix boxes



Discuss about QA in Mainframe, Back-End Test, Offline code testing and Testing Tools

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
v1gnesh
 
Posts: 72
Joined: Wed Sep 28, 2011 8:24 pm
Has thanked: 1 time
Been thanked: 0 time

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.

These users thanked the author dick scherrer for the post:
v1gnesh (Sun Jul 15, 2012 5:19 am)
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

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
v1gnesh
 
Posts: 72
Joined: Wed Sep 28, 2011 8:24 pm
Has thanked: 1 time
Been thanked: 0 time

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
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

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.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

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.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

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
v1gnesh
 
Posts: 72
Joined: Wed Sep 28, 2011 8:24 pm
Has thanked: 1 time
Been thanked: 0 time

Previous

Return to Application Testing

 


  • Related topics
    Replies
    Views
    Last post