File transfer from Mainframe to unix loosing spanish Charact



Post anything related to mainframes (IBM & UNISYS) if not fit in any of the above categories

Re: File transfer from Mainframe to unix loosing spanish Cha

Postby Robert Sample » Fri Aug 18, 2017 1:55 am

N tilde should be X'A0' while the # symbol is X'23'; I'm not sure why they are getting crossed.
Robert Sample
Global moderator
 
Posts: 3364
Joined: Sat Dec 19, 2009 8:32 pm
Location: East Dubuque, Illinois
Has thanked: 1 time
Been thanked: 221 times

Re: Re: File transfer from Mainframe to unix loosing spanish Cha

 

Re: File transfer from Mainframe to unix loosing spanish Cha

Postby Nagesh_ZOS » Fri Aug 18, 2017 3:43 am

Hi Robert,

Thanks alot. Can you suggest if there is any way to transfer these files without losing spanish characters.

Thanks,
Nagesh.
Nagesh_ZOS
 
Posts: 14
Joined: Wed Aug 16, 2017 10:48 pm
Has thanked: 0 time
Been thanked: 0 time

Re: File transfer from Mainframe to unix loosing spanish Cha

Postby Robert Sample » Fri Aug 18, 2017 4:47 pm

First, mainframes have "files" in Unix System Services and on tape only. Disk allocations are ALWAYS "data sets" and calling them "files" is just plain WRONG.

Second, FTP is the way to transfer data sets to other platforms. Some sites purchase other solutions (for example, Connect:Direct) but unless your site has purchased such a solution, you will need to use FTP.

Third, you may have to experiment -- possibly dozens of times -- with FTP jobs to get the parameters right for the transfer you want to do. SBD=(IBM-284,?) is most likely what you'll need but what code page to replace the ? is what you need to figure out.

Fourth, one possibility would be to transfer the data set as binary, then write your own translation program on the Linux system to convert EBCDIC to ASCII (preserving the Spanish characters).
Robert Sample
Global moderator
 
Posts: 3364
Joined: Sat Dec 19, 2009 8:32 pm
Location: East Dubuque, Illinois
Has thanked: 1 time
Been thanked: 221 times

Re: File transfer from Mainframe to unix loosing spanish Cha

Postby vasanthz » Sat Aug 19, 2017 2:08 am

You keep saying spanish charaters, But I highly doubt it is spanish.

To test your scenario.

Go to the Mainframe source file. Have only two lines of data and the data should produce the "spanish charaters" when sent.
Do a HEX ON in the file and post it here. That would give the input file.

For the output file, if you have NOTEPAD++, then open the transferred file using "Hex-Editor Plugin for Notepad++"
This would give you hexadecimal values that were transferred. Post the hex format of the output file.

We would be able to identify the root cause once you have the input & output data.
User avatar
vasanthz
 
Posts: 14
Joined: Thu Aug 05, 2010 2:53 pm
Has thanked: 2 times
Been thanked: 0 time

Re: File transfer from Mainframe to unix loosing spanish Cha

Postby Nagesh_ZOS » Wed Aug 23, 2017 3:01 am

Hi Vasanthz,

Thanks alot for quick reply.
Mainframe Hex on giving me below output.

FRANCISCO VILLASEÑOR
CDCDCCECD4ECDDCEC6DD
69153923605933125969
Nagesh_ZOS
 
Posts: 14
Joined: Wed Aug 16, 2017 10:48 pm
Has thanked: 0 time
Been thanked: 0 time

Re: File transfer from Mainframe to unix loosing spanish Cha

Postby Nagesh_ZOS » Wed Aug 23, 2017 3:10 am




Please find the attachment that I tried to see the special character with conversion table.

If anyone had any syntax to convert EBCIDIC to UTF-8 that would help alot. I am planning to load this on to oralce and these are inserted as it is, I mean the special character is not decoded while loading with sqlloader.



Thanks,
Nagesh.
You do not have the required permissions to view the files attached to this post.
Nagesh_ZOS
 
Posts: 14
Joined: Wed Aug 16, 2017 10:48 pm
Has thanked: 0 time
Been thanked: 0 time

Re: File transfer from Mainframe to unix loosing spanish Cha

Postby vasanthz » Wed Aug 23, 2017 3:11 am

ok.
How does the file look on the receiving side? with hex data
User avatar
vasanthz
 
Posts: 14
Joined: Thu Aug 05, 2010 2:53 pm
Has thanked: 2 times
Been thanked: 0 time

Re: File transfer from Mainframe to unix loosing spanish Cha

Postby Nagesh_ZOS » Wed Aug 23, 2017 3:25 am

output_2.jpg
You do not have the required permissions to view the files attached to this post.
Nagesh_ZOS
 
Posts: 14
Joined: Wed Aug 16, 2017 10:48 pm
Has thanked: 0 time
Been thanked: 0 time

Re: File transfer from Mainframe to unix loosing spanish Cha

Postby vasanthz » Wed Aug 23, 2017 3:56 am

Hi,

I was able to recreate your issue.

Sent
FRANCISCO VILLASEÑOR
CDCDCCECD4ECDDCEC6DD
69153923605933125969


using standard FTP.
server                        
userid
password      
ASCII                              
PUT  'WELLS.DOGE' spanish.txt  
quit                    


Ñ was converted to x'ac' which is ¬

Sent using the below control cards,
server                        
userid
password
locsite sbd=(IBM-1047,ISO8859-1)      
ASCII                              
PUT  'WELLS.DOGE' spanish.txt
quit                    


Ñ was converted to x'd1' which is Ñ . http://www.simotime.com/asc2ebc1.htm confirms that the translation is correct.

Can you try this option? Or have you tried this already and facing issues with this?
User avatar
vasanthz
 
Posts: 14
Joined: Thu Aug 05, 2010 2:53 pm
Has thanked: 2 times
Been thanked: 0 time

Re: File transfer from Mainframe to unix loosing spanish Cha

Postby Nagesh_ZOS » Wed Aug 23, 2017 8:13 am

Thanks alot Vasanthz. I will try the above options and will post the results.

Thanks,
Nagesh.
Nagesh_ZOS
 
Posts: 14
Joined: Wed Aug 16, 2017 10:48 pm
Has thanked: 0 time
Been thanked: 0 time

PreviousNext

Return to All other Mainframe Topics

 


  • Related topics
    Replies
    Views
    Last post