Loading data into tables in a distributed relational database

 

Applications in the distributed relational database environment operate on data stored in tables. In general, applications are used to query a table for information; to insert, update, or delete rows of a table or tables; or to create a new table. Other situations occur where data on one system must be moved to another system.

• Loading new data into the tables of a distributed relational database
  You load data into a table by entering each data item into the table. On the i5/OS operating system, you can use SQL, the DB2 Universal Database™ for iSeries™ Query Management function, or the data file utility portion of iSeries Application Development Tools to create applications that insert data into a table.

• Moving data from one system to another
  A number of situations occur in enterprise operations that might require moving data from one i5/OS operating system to another.

• Moving a database to i5/OS from a system other than i5/OS
  You might need to move a file from another IBM^® system to the i5/OS operating system or from a non-IBM system to i5/OS. This topic collection lists alternatives for moving data to the i5/OS from a system other than i5/OS. However, refer to manuals supplied with the other system or identified for the application for specific instructions on its use.

 

Parent topic:

Initial setup