Data Movement

Index information lost when the import utility is used

You can use the import utility to recreate a table that was saved through 8the export utility.

The Data Movement topic "Using import to 8recreate an exported table" outlines attributes of the original table are not retained. In addition to the attributes which 8have already been documented, the following attributes are not retained:

8
• Index information: 8
  8
  • Include columns (if any)
  8
  • Index name, if the index is a primary-key index
  8
  • Descending order, if the index is a primary-key index (Ascending is the 8default)