Spanish Characters not in proper format for ftp mainframe

IBM OS/370, MVS, OS/390, Linux, TPF, VM/CMS, VM/ESA, VSE/ESA, z/VM, z/VSE, z/OS, z/OS.e etc...
Nagesh_ZOS
Posts: 13
Joined: Wed Aug 16, 2017 10:48 pm
Skillset: DB2 DBA
Referer: online

Spanish Characters not in proper format for ftp mainframe

Postby Nagesh_ZOS » Wed Aug 16, 2017 11:17 pm

Hi All,

I am transfering some files using ftp JCL . On the Unix side I see that some spanish characters are showing as some escape character. I need to load this file into Oracle database. I tried Manually converting from ebcdic to UTF but I am loosing delimited values after the conversion using the DD command and iconv. so My load to Oracle db is failing. Can someone help me what parameters should I set in the FTP JCL so that EBCDIC to ASCII or UTF8 conversion is taken care by the FTP on the mainframe side.

Thanks,
Nagesh

Robert Sample
Global moderator
Posts: 3720
Joined: Sat Dec 19, 2009 8:32 pm
Skillset: Systems programming, SAS, COBOL, CICS, JCL, SMS, VSAM, etc.
Referer: other forum
Location: Dubuque, Iowa, USA

Re: Spanish Characters not in proper format for ftp mainfram

Postby Robert Sample » Wed Aug 16, 2017 11:41 pm

I moved your other topic from Forum Rules. You do not need to post multiple times in different areas of the forum. Topic locked.


  • Similar Topics
    Replies
    Views
    Last post