Insert a row in a table
To insert a row in a table, you must have authorization to the table.
- In the System i Navigator window, expand the system you want to use.
- Expand Databases.
- Expand the database and schema that you want to work with.
- Click the Table container.
- Right-click the table and select Edit Contents.
- From the Rows menu, select Insert. The new row will appear.
- Update the fields in the new row. The values you enter must satisfy all constraints and satisfy the
type of each field. If there is a unique constraint or index over the table, the values you enter
must define a unique key value. If you do not enter a value in a field, the default value will be entered, if allowed.
- From the File menu, select Save and then Close.