Data Movement Utilities Guide and Reference


Using Export with Identity Columns

The export utility can be used to export data from a table containing an identity column. If the SELECT statement specified for the export operation is of the form "select * from tablename", and the METHOD option is not used, exporting identity column properties to IXF files is supported. The REPLACE_CREATE and the CREATE options of the IMPORT command can then be used to recreate the table, including its identity column properties. If such an IXF file is created from a table containing an identity column of type GENERATED ALWAYS, the only way that the data file can be successfully imported is to specify the identityignore modifier. Otherwise, all rows will be rejected (SQL3550W).


[ Top of Page | Previous Page | Next Page ]