EBCDIC Database File Problem

75 pts.
Tags:
AS/400 database
AS400 Data Definitions
COBOL
Database Files
EBCDIC
FTP
IBM iSeries
My company received a file supposedly in EBCDIC format. We copied it to the shared network drive and attempted to FTP it several different times using several different types. The file transferred but when displaying it the records were all variable length and appears to have CR or EOL special characters. What I'm attempting to accomplish is to FTP it to the iSeries in simply a flat fixed length file. I was told it came from a zOS mainframe and looking at the file layout it mentions COBOL. Any ideas? Thanks.

Answer Wiki

Thanks. We'll let you know when a new response is added.

I work on mainframe where (almost) everything is EBCDIC*. I often FTP a dataset (file) from mainframe to PC – like a report – so I can email it. I always specify TEXT. My (our) FTP translates from EBCDIC to ACSII just fine.

* even mainframe is *slowly* moving from EBCDIC. Headed to UNICODE. DB2 is leading the way. The current version of DB2 on z/OS, the SYSIBM tables are all UNICODE. So maybe, eventually, we can dump all this translation and just live in a UNICODE world.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    Paste a few representative lines from the file or from a display the file, please. Also include any file attributes. Thank you. Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following