Restrictions for exporting data using nicknames

There are restrictions on using the EXPORT command to export data from a query that references a nickname.

The following restrictions apply when you use the EXPORT command to export data using a nickname:
  • The description of the target table that is necessary to perform the import CREATE operation is not saved in the IXF file format. Use the db2look utility to collect the information that you need to recreate the table.
  • You can export data into the IXF and DEL file types. The ASC file type is not supported for exporting data from nicknames.