Copying files that contain identity columns or ROWID attributes

 

You can specify CRTFILE (*YES) on the CPYF and CPYFRMQRYF commands when you copy files that contain identity columns or ROWIDs.

If the from-file is an SQL table, view, or index that contains an identity column or ROWID, these commands create an SQL table.

When you copy to files that contain an identity column or ROWID, you can either supply a value or have the system generate a value for the field.

 

Parent topic:

Copying complex objects

 

Related information

CPYF command
CPYFRMQRYF command