Edit data in a table

To edit data 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 Tables container.
  5. Right-click the table and select Edit Contents.
  6. Click the cell that you want to edit.
  7. Edit the data in the cell. If you want to cancel your changes, press the Escape key.
  8. When you finish editing, go to the File menu and select Save. To close choose Exit.

To refresh the data in the table, select Refresh from the View menu. If there are any changes that you have not saved, you will be prompted to save them. A refresh can only be done if all pending changes are saved or canceled. When the data is refreshed, any changes that you made are reflected. The rows in the refreshed data may appear in a different order. Rows do not necessarily appear in key order.