Identity column export considerations

You can use the export utility to export data from a table containing an identity column. However, the identity column limits your choice of output file format.

If the SELECT statement that you specify for the export operation is of the form SELECT * FROM tablename and you do not use the METHOD option, exporting identity column properties to IXF files is supported. You can then use the REPLACE_CREATE and the CREATE options of the IMPORT command to re-create the table, including its identity column properties. If you create the exported IXF file from a table containing an identity column of type GENERATED ALWAYS, the only way that you can successfully import the data file is to specify the identityignore file type modifier during the import operation. Otherwise, all rows are rejected (SQL3550W is issued).