Creating an external table

Create a table that is managed and stored outside of the database server to load and unload data.

Prerequisite: To create external tables, the HCL OpenAdmin Tool (OAT) for Informix® requires HCL Informix version 11.50.xC6.

To create an external table:

  1. On the OAT menu, click SQL Toolbox > Schema Manager.
  2. Select the database for which to create the table.
  3. On the Actions menu, click Create Table.
  4. Follow the directions in the Create Table wizard.
    For Table type, select an external table type:
    • External Fixed: A table in fixed-width text format whose data is managed and stored outside of the Informix database server.
    • External Delimited: A table in delimited text format whose data is managed and stored outside of the Informix database server.
    • External Informix: A table in internal Informix format whose data is managed and stored outside of the Informix database server.

      External tables are used to load and unload data for your database.


Copyright© 2018 HCL Technologies Limited