Adding New Records

Once a table has been defined and before any data can be retrieved, data must be entered into the table. Initially, data can be entered into the table in several ways:

• Batch mode: Data is loaded into the table from a file.

• Interactive mode: Data for each record is added by interactive prompting of each column in a record.

• Line Input: A row of data is keyed for insertion into a table using a line editor and then is submitted to the database.

Generally a Load Program would be used to load data into the tables at the outset. It would be unusual to use line input especially to get started, but it is used in the following examples so that the correct syntax can be clearly seen.