Loading data with an external table

Load data into a database table from a source that is external to the database server by using 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 load data with an external table:

  1. On the OAT menu, click SQL Toolbox > Schema Manager.
  2. Select the database table to load the data into.

    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 Load Table.
  4. Follow the directions in the Load Table wizard.

Copyright© 2018 HCL Technologies Limited