Often, the initial rows of a table can be derived from data that is stored in tables in another Informix database or in operating-system files. The following utilities let you move large quantities of data:
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 could 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;Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]