I would like to know what are all the File transfer modes available to transfer a file from Mainframe to UNIX. Also i would like to know if the format of the file will change when one edit the transferred file in UNIX environment.
My Understanding is : Files in Mainframe are stored in EBCDIC format and when transferred to UNIX Box will become ASCII formatted. Is my understanding is correct ?
Also I have a query , I need to read a Packed decimal (Comp - 3) in oracle sql * loader . Will oracle sql * loader supports reading packed decimal formats..
Joined: 12 Sep 2005 Posts: 54 Location: Paris France
Hi Firend
Several way exist for to do face at your problem. The most simple and economical is FTP, default supply for TCP/IP stack IBM and lot other OS like UNIX. You can define some convertions tables for assure data integrity. If you aren't sure about data format you can use binary transfert.
Another way is use a file transfert product like CFT or INTERPEL. The cost isn't negligible and installation and tuning require some time.
