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.

• Loading data into a table using SQL
  A simple method of loading data into a table is to use an SQL application and the SQL INSERT operation.

• Manipulating data in tables and files using the i5/OS query management function
  The i5/OS licensed program provides a DB2 Universal Database for iSeries query management function that allows you to manipulate data in tables and files. A query is created using an SQL query statement.

• Entering data, update tables, and make inquiries using data file utility
  The data file utility (DFU), which is part of the iSeries Applications Development Tools package available from IBM^®, is a program builder that helps you create programs to enter data, update tables, and make inquiries.

 

Parent topic:

Loading data into tables in a distributed relational database