Importing/copying external EBCDIC files to DB2 on iseries

0 pts.
Tags:
AS/400
COBOL
DB2
Development
This seems kind of obvious, but we can't figure it out. Another company has sent us (via email) an EBCDIC file and we want to load it on to our iseries. What's the ticket? We've tried CPYFRMPCD and a couple of other things, but we get conversion errors? Any thoughts out there?
ASKED: December 27, 2004  4:48 PM
UPDATED: October 10, 2010  3:42 AM

Answer Wiki

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

I’m not an expert on iSeries, but as far as I know EBCDIC has a different conversion table than ASCII. Have you tried the type-of format?.

Discuss This Question: 5  Replies

 
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
  • Dcrocker63
    Did you specify *NONE for translation table?? If you did, I would just FTP the file directly to a file on your AS/400. Or if the file is a comma delimented file, try the copy from inport file command, cpyfrmimpf.
    0 pointsBadges:
    report
  • Apothen
    Have you tried using the client access data transfer function. If you click on the details button and then uncheck the "Use PC file description" option. In the file type drop down menu, there is an option for "No Conversion". I have never tried this before, so if you have the time, try it and see what happens. Ajish
    0 pointsBadges:
    report
  • Steinhah
    Try CPYFRMSTMF with CVTDTA(*NONE). It might work. Good luck.
    0 pointsBadges:
    report
  • TheQuigs
    Wouldn't it depend on how the file was exported from the iSeries? If you can find out how it was exported that will be the key. i.e., If they used the PC5250 data transfer function specifying "No Conversion", then I would use data transfer to get it back onto an iSeries.
    0 pointsBadges:
    report
  • TomLiotta
    Another company has sent us (via email) an EBCDIC file... First, EBCDIC files aren't compatible with SMTP since SMTP only allows 7-bit ASCII characters. So, some definition needs to be supplied that describes the e-mail process on both ends as well as describes the 'EBCDIC' file. How was it transferred into the system that e-mailed it? How was the file packaged for e-mail? How can you tell that it's EBCDIC? Where was it extracted from the e-mail -- on an ASCII PC? How was it transferred to your AS/400, as binary or text? You mentioned 'CPYFRMPCD', so you must have somehow gotten it into the /QDLS file system. How? Why would you use CPYFRMPCD if you already had it in /QDLS? What are you copying into? There are too many systems doing possible encoding conversions. To provide any help, we need to know much more about the processes and the data. The data needs to be described in terms of CCSID. The file itself probably should be described so that we might give some guesses on what has happened. Questions like this can almost always be given a correct answer. They just need some info to work with. 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