Import data

Use the Import wizard to load data from a data file into a table. This wizard uses the CPYFRMIMPF command to process this request.

You can import 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.

Note: System i Navigator refers to an import file as a data file.

To import 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 import data to and select Data -> Import.