Exporting a member from a library to a IBM Risc 6000

Exporting a member from a library to a IBM Risc 6000

I was exporting a member from a library to a IBM Risc 6000. I was using a third party SQL report write to write to the file in a comma delimited format. The file would not break at the end of the record. The format was ASCII. It did not seem to matter what changes I made to the CCSID of the file it would not break each record properly. I was able to use FTP to bring the file over to the physical file. Have you ever come across this type of problem, or do you know how to resolve it. I am using OS400 V4R4 and AIX 4.3.2


    Requires Free Membership to View

    Login

    Register today to access targeted resources from our editorial writers and independent industry experts including news, tips, and advice to help you do your job more efficiently and effectively. Stay informed on the hottest topics and biggest challenges faced by IT professionals working with iSeries products and services.

    By submitting your registration information to Search400.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of Search400.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

I would use the CPYTOIMPF command to create the CSV file instead of your SQL report writer. Search 400 has several good tips on the CPYTOIMPF command. Following are two that you will probably want to check out:

Creating ASCII import files in root file system (IFS)

How do I take an AS/400 file and convert it to a comma separated file?


This was first published in May 2001

Back to top