Selecting the records to copy

The following topics show how you can use parameters on the copy commands to select only the specific records that you want to copy:

• Selecting records using a specified record format name (RCDFMT Parameter)
• Selecting records by relative record numbers (FROMRCD and TORCD Parameters)
• Selecting records by record keys (FROMKEY and TOKEY Parameters)
• Selecting a specified number of records (NBRRCDS Parameter)
• Selecting records based on character content (INCCHAR Parameter)
• Selecting records based on field value (INCREL Parameter)
• Copying deleted records (COMPRESS Parameter)

The copy command parameters for record selection (FROMRCD, TORCD, FROMKEY, TOKEY, INCCHAR, and INCREL) are not on the CPYFRMQRYF command because you select records on the OPNQRYF command.

See the Database Programming book for details on record selection by using open query file. For a detailed description of all considerations for each parameter, see the CL Programming book.