Move data from other IBM Informix databases
Often, the initial rows of a table can be derived from
data that is stored in tables in another IBM®
Informix® database
or in operating-system files. The following utilities let you move
large quantities of data:
- onunload and onload utilities
- dbexport and dbimport utilities
- dbload utility
- SQL LOAD statement
- High Performance Loader (HPL)
You can also select the data you want from the other database
on another database server as part of an INSERT statement in your
database. As the following example shows, you can select information
from the items table in the demonstration database to insert
into a new table:
INSERT INTO newtable
SELECT item_num, order_num, quantity, stock_num,
manu_code, total_price
FROM stores_demo@otherserver:items;