Importing data with Enterprise Gateway products

You can use IBM® Informix® Enterprise Gateway with DRDA to query a DRDA database and then insert the results into yourInformix database.

For example, to import data, run a SELECT statement to select data from the other database and then run an INSERT statement to insert data into the Informix database. For more information, refer to the IBM Informix Enterprise Gateway with DRDA User Manual.

IBM Informix Enterprise Gateway provides a single, standards-based gateway to multiple data sources. Gateway Manager connects the Informix environment with that of any shared-library ODBC Level 2-compliant driver manager and driver on UNIX or Linux®. For instance, you can use Gateway Manager with the IBM Informix Enterprise Gateway driver products to access UNIX or Linux database server products. For more information, refer to the IBM Informix Enterprise Gateway with DRDA User Manual.