Using the Copy From Import File (CPYFRMIMPF) command to copy between different systems

 

The Copy From Import File (CPYFRMIMPF) command maps or parses the data from ("import") an import file to the to-file.

Depending on what type of file the import file is, there are different steps to use when running CPYFRMIMPF.

The CPYFRMIMPF command also supports a parallel data loader to copy information from an import file to a to-file using multiple jobs during the copy operation. To use multiple jobs, the system must have the i5/OS^® operating system option DB2^® Symmetric Multiprocessing (SMP).

• Notes on the CPYFRMIMPF command
  The authority needed to perform the copy using the CPYFRMIMPF command is similar to the authority requirements for all other copies.

• Restrictions on the CPYFRMIMPF command
  There are certain restrictions that apply to the CPYFRMIMPF command.

• Importing data to the System i platform when the from-file is a database file or DDM file
  You can use the Copy from Import File (CPYFRMIMPF) command to import data from a database file or DDM file.

• Importing data to the System i platform when the import file is a stream file
  You can use the Copy from Import File (CPYFRMIMPF) command to import data from a stream file.

• Parallel data loader support to use with the CPYFRMIMPF command
  The Copy From Import File (CPYFRMIMPF) command supports copying the data in parallel from an import file to a to-file using multiple jobs during the copy operation. This allows you to copy data files from other platforms into a to-file quickly and easily. This is especially useful for those who use data warehousing. To use multiple jobs, your system must have the i5/OS operating system option DB2 Symmetric Multiprocessing (SMP).

• Handling data from the import file
  The Copy From Import File (CPYFRMIMPF) reads data from an import file and copies the data to a to-file. The data of the import file can be formatted by delimiters or in a fixed format.

• Notes on the delimited import file (CPYFRMIMPF command)
  The characters and data types discussed in this topic interpret the import file's data for a delimited import file.

• Fixed formatted import file
  This topic gives an example of a Field Definition File that describes the fixed formatted file.

• Improving the performance of the CPYFRMIMPF command
  To improve the performance of the CPYFRMIMPF command, follow these steps.

 

Parent topic:

Copying between different systems

 

Related concepts

Notes on the CPYFRMIMPF command
Restrictions on the CPYFRMIMPF command
Parallel data loader support to use with the CPYFRMIMPF command

 

Related tasks

Importing data to the System i platform when the import file is a stream file
Importing data to the System i platform when the from-file is a database file or DDM file