MVSFORUMS.com

ksandy · Beginner Joined: 27 Mar 2003 Posts: 18 Topics: 11

Hi

One of our mainframe application takes data from Oracle (11i).

Oracle supports special characters in Kanji (Japanese addresses) . However when I ftp the flat file (which is dump of Oracle database ) to mainframe , all these special characters badly affects the input data and its format.

Data looks perfectly correct in Oracle database but when it gets dumped into flat file , all problem starts .

Is there any kind of utility (either at MF end or Oracle end )which takes care of any special characters ?

Or Is there any different way to approach this problem ?

Thanks
Ksandy

kolusu · Posted: Mon May 05, 2003 5:49 pm Post subject:

ksandy,

FTP supports KANJI character conversion. check this link for detailed explanation on setting up the data transfer mode

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/F1A1B910/CCONTENTS

You need to look into topics 5.21 , 5.28, 5.64

Hope this helps...

cheers

kolusu