Unloading data to an external table

Unload data from a database table to an external table.

Prerequisite: To load and unload data with external tables, the HCL OpenAdmin Tool (OAT) for Informix® requires HCL Informix version 11.50.xC6 or later.

To unload data to an external table:

  1. On the OAT menu, click SQL Toolbox > Schema Manager.
  2. Select the database table from which to unload the data.

    To find a table, type any part of the table name in the Find field, and click Search. You can also expand a database to display the tables.

  3. On the Actions menu, click Unload Table.
  4. Follow the directions in the Unload Table wizard.
Parent topic: Loading and unloading data with external tables
Copyright© 2018 HCL Technologies Limited