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 server generate a value for the field.

You cannot copy DDM files that contain identity columns or ROWIDs to iSeries servers running at version 5 release 1 or earlier.