Importing and exporting data

 

iSeries™ Navigator provides Import and Export wizards for you to import and export data between files and database tables. These wizards use the Copy from Import File (CPYFRMIMPF) and Copy to Import File (CPYTOIMPF) commands to process the requests. Here are the files and database tables that you can import data from or export data to:

• Integrated file systems files

• Source physical files

• Program-described files

• Database tables with a single nonnumeric column that is not data type LOB

iSeries Navigator refers to an import file as a data file.

To start the Import or Export wizard, follow these steps:

1. From iSeries Navigator, 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. If you want to import data from a data file, right-click the table that you want to import data to and select Data > Import. If you want to export data in a table to a file, right-click the table that you want to export data to and select Data > Export.

 

Parent topic:

iSeries Navigator database tasks

 

Related tasks

Copying between different systems

 

Related reference

Copy From Import File (CPYFRMIMPF) command
Copy To Import File (CPYTOIMPF) command