Notes on the Copy to Import File command

The Copy to Import File (CPYTOIMPF) command reads data from a user from-file and copies it into an import file. The number of jobs used for copy is one. The data of the import file can be formatted by delimiters or it can be in a fixed format.

Notes on the delimited import file (CPYTOIMPF command) has a series of characters (delimiters) that are used to define where fields begin and end. See Restrictions for the Copy to Import File command for more information.

The parameters of the command define which characters are used for delimiters. A fixed format import file uses a fixed format. For more information, see Copying data to the import file in a fixed format (CPYTOIMPF command).

The data in the from-file is read from the formatted database file and written to the import file with the parameters from the command.

If a user profile exists for the same library name that is being copied from, at least one of the following authority will be needed:
  • The system authority *ADD to the user profile with that name.
  • Administrative authority
The from-file can be any of these:
  • A source physical file
  • A program described physical file
  • A distributed physical file
  • A single format logical file
  • An externally described physical file
The to-file can be any of these:
  • a stream file
  • a source physical file
  • a program described physical file
  • a distributed physical file with one non-numeric field
  • an externally described physical file with one non-numeric field