How to transfer file from Mainframe to UNIX

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
rakesh.nc
Participant
Posts: 39
Joined: Wed Aug 01, 2007 5:10 am
Location: Chennai

How to transfer file from Mainframe to UNIX

Post by rakesh.nc »

is it possible using FTP Plug-in Stage.
regards,
Rakesh
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Yes, you can use the FTP stage to do this; but you need to make sure that the systems have been configured to talk to each other.
stefanfrost1
Premium Member
Premium Member
Posts: 99
Joined: Mon Sep 03, 2007 7:49 am
Location: Stockholm, Sweden

Post by stefanfrost1 »

also if your file has compressed values on the mainframe then they might get converted to linebreakers or hex null values on unix and you may not be able to read it as you wish.

Good practice is to first (on the mainframe) convert any special charachters or compressions to normal text and then ftp over to unix.
-------------------------------------
http://it.toolbox.com/blogs/bi-aj
my blog on delivering business intelligence using agile principles
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

If you do a binary transfer, i.e. with COMP-3 fields in the file, you won't need to do a conversion on the mainframe; but it does make life easier when you have EBCDIC (or ASCII) text only files.
stefanfrost1
Premium Member
Premium Member
Posts: 99
Joined: Mon Sep 03, 2007 7:49 am
Location: Stockholm, Sweden

Post by stefanfrost1 »

true, however I have had trouble with COMP-3 fields when transfering binary from mainframe to unix using a program called ConnectDirect. After many different trials and errors we decided to "decompress" on the mainframe and send in plain text and got our following programs to function....
-------------------------------------
http://it.toolbox.com/blogs/bi-aj
my blog on delivering business intelligence using agile principles
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Stefan - I think the ConnectDirect or mainframe issue is that some files can have compressed spaces which are not interpreted/expanded correctly when doing such transfers. The compressed spaces binary values can sometimes show up in COMP-n fields and thus cause the file to be expanded incorrectly.
rakesh.nc
Participant
Posts: 39
Joined: Wed Aug 01, 2007 5:10 am
Location: Chennai

Post by rakesh.nc »

ArndW wrote:Stefan - I think the ConnectDirect or mainframe issue is that some files can have compressed spaces which are not interpreted/expanded correctly when doing such transfers. The compressed spaces binary ...

what are all the connection details are need for transfer the fail from Mainfram to Unix/local environment.
regards,
Rakesh
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

These will be speific to your site. We can not advise. Consult your network administrator.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
stefanfrost1
Premium Member
Premium Member
Posts: 99
Joined: Mon Sep 03, 2007 7:49 am
Location: Stockholm, Sweden

Post by stefanfrost1 »

Stefan - I think the ConnectDirect or mainframe issue is that some files can have compressed spaces which are not interpreted/expanded correctly when doing such transfers. The compressed spaces binary ...
ArndW! Is there a way to handle (other than fixing the files before sending) what you are describing?
-------------------------------------
http://it.toolbox.com/blogs/bi-aj
my blog on delivering business intelligence using agile principles
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Only a few operatings sytems will do this. I recall having seen this on PRIMOS and some mainframe system (it might have been Hitachi, but that is only a guess). This won't be an issue for most systems; if you check your mainframe file system documentation you will find out if it does multiple space compression. If it does, and you have COMP-3 or other binary fields, then you will need to do a binary transfer and then do the EBCDIC->ASCII conversion on the server side.
Post Reply