Data Movement Utilities Guide and Reference

Recreating an Exported Table

You can use the import utility to recreate a table that was saved through the export utility. The table must have been exported to an IXF file, and the SELECT statement used during the export operation must have met certain conditions (for example, no column names can be used in the SELECT clause; only select * is permitted). When creating a table from an IXF file, not all attributes of the original table are preserved. For example, referential constraints, foreign key definitions, and user-defined data types are not retained. The following attributes of the original table are retained:

• Column information:

  • Names.

  • Types, including user-defined distinct types, which are preserved as their base type.

  • Lengths (except for lob_file types).

  • Code pages (if applicable).

• Index information:

  • Name.

  • Creator.

  • Column names of key parts (with a restriction if + or - is in the names).

  • Ascending or descending.

  • Uniqueness.

[ DB2 List of Books | Search the DB2 Books ]