Home | Previous Page | Next Page   Basics of Database Design and Implementation > Implementing a Relational Data Model > Populating the Database >

Moving Data from Other Informix Databases

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 ]