Accessing Auxiliary Storage: FILE › DB2 and SQL/DS Databases › FILE Functions for DB2 and SQL/DS Databases › Insert a Row

Insert a Row

The INSERT command lets you insert an entire row of data. First specify the column names, and then specify the values to insert into each column. Set conditions to determine when the insertion should be performed.

• Insert only one row of data at a time.
• You must specify data for each column in the table, except for columns that contain nulls, which are identified by asterisks.

Example

To insert employee data into a table, specify the following, and then press Enter:

INSERT INTO DSN8130.TEMPL 
(EMPNO,FIRSTNME,MIDINIT,LASTNAME,WORKDEPT,SALARY)
VALUES(`010200',`JAMES',`S',`NEWMAN',`D11',27500)

FILE inserts a row into table DSN8130.TEMPL. This row contains six columns of information for employee James S. Newman.

Before performing the insertion, FILE displays a second screen asking you to confirm or cancel the insertion. Enter C to confirm or R to cancel the insertion.