How to Create a CSV File From an AS400 File With Column Headings

Written by bonnie conrad
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Create a CSV File From an AS400 File With Column Headings
You can convert mainframe files to CSV format. (Jupiterimages/Photos.com/Getty Images)

The AS/400 file format is proprietary, meaning that you must have a specific type of software loaded to create or use it. But the comma separated value (CSV) file is more universal. You can read a CSV file into a number of different programs, including text editor programs, Microsoft Access databases and Microsoft Excel spreadsheets. Converting an existing AS/400 database file into a standard CSV format makes it available to a much larger audience of users.

Skill level:
Moderately Easy

Other People Are Reading

Instructions

  1. 1

    Open the AS400 file you wan to convert. Type the command "CRTPF FILE(USER999/CSVPC)" to create a blank CSV file to which you can transfer that AS400 data.

  2. 2

    Press the "F4" key. Type the record length you want to use for the file. Enter a name for the CSV file.

  3. 3

    Type the command "CPYTOIMPF FROMFILE(*LIBL/DTAFIL) TOFILE(USER 999/CSVPC)" and press the "Enter" key. Press "Enter" three more times to complete the creation of the CSV file.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.