Load Table

Use this page to load data into a database table from an external source.

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

Load data into table name

Specify how to load the data.

Load data into table name using the same schema
Select this option to automatically create an external table that has the same schema as the selected database table. The data is loaded from the external table into the database table, and then the external table is dropped.
Load the data from a previously defined external table
Select an existing external table from which to load the data.

Copyright© 2018 HCL Technologies Limited