Insert a row in a table

To insert a row in a table, you must have authorization to the table.

  1. In the System i Navigator window, expand the system you want to use.
  2. Expand Databases.
  3. Expand the database and schema that you want to work with.
  4. Click the Table container.
  5. Right-click the table and select Edit Contents.
  6. From the Rows menu, select Insert. The new row will appear.
  7. 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.
  8. From the File menu, select Save and then Close.