Export data

Use the Export wizard to export data from a table to a data file. This wizard uses the CPYTOIMPF command to process this request.

You can export data to an integrated file systems file or a source physical file as well as program described files or a database table with a single non-numeric column. The column cannot be a LOB data type.

To export data:

  1. In the System i Navigator window, expand the system you want to use.
  2. Expand Databases.
  3. Expand the database and schema that you want to work with.
  4. Click the Tables container.
  5. Right-click the table that you want to export data from and select Data -> Export.