Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

FTP from mainframe to UNIX server without loss of data

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
sanjaygkk
Currently Banned

New User


Joined: 27 Oct 2006
Posts: 1
Location: Bangalore

PostPosted: Fri Mar 09, 2007 2:08 pm    Post subject: FTP from mainframe to UNIX server without loss of data
Reply with quote

HI all

MY question is i am able to FTP it , but some of the data giving junk value , that too only for COMP fileds , so how to FTP without the loss of data
Back to top
View user's profile Send private message

William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Sat Mar 10, 2007 4:02 am    Post subject:
Reply with quote

Do you understand what code pages are?
An "A" in EBCDIC will translate to an "A" in ASCII without any problem, but a lot of the possible byte configurations translate not so well.
Data is of the form of character, packed decimal and binary; character data translate well, packed and binary does not.
You have to decide, either transfer without translation and the receiver will have to translate the character data or transfer with translation and the sender will have to "un-binarize" and un-pack the numeric date.
Your choice, what'ch go'na do? icon_smile.gif
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Sat Mar 10, 2007 4:45 am    Post subject:
Reply with quote

I would suggest to translate data with all COMP fields to NUMERIC and then FTP the file.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Mar 10, 2007 6:57 am    Post subject:
Reply with quote

Hello,

To successfully and easily transmit mainframe data to unix (or windows) make sure that the file to be transmitted is entirely in text format.

Due to the way individual bytes are converted from EBCDIC to ASCII you will get erroneous/unpredictable results if you transmit any packed or binary data.

Several bit patterns translate into ascii control characters and the target system does not know a "real" control character from a "fake" one. One of the most common is an embedded x'09' (which happens often in packed numbers) and is a tab-character on many target systems.

There are not many applications that do this any more, but if your application chose to use bit-switches (because there were a high number of fields whose value was restricted to yes/no, and disk space was expensive then), those will not transmit correctly.

To repeat, you will be way ahead if you expand all of your numbers on the mainframe and send a clean file to the ascii system.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts copying data without knowing location arunsoods DFSORT/ICETOOL 5 Thu Jul 20, 2017 1:03 pm
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm
No new posts Mainframe Opening in Chennai ( 2 to 4... muralikrishnan_new Mainframe Jobs 0 Tue Jul 18, 2017 2:20 pm
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 16 Thu Jul 13, 2017 2:11 pm
No new posts SQL - select data available in index Nileshkul DB2 3 Mon Jun 26, 2017 1:30 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us