Procedure documentationChanging Data in the Database Locate this document in the navigation structure

 

You add a data record to a table, update a data record, or delete a data record. To do so, use the table editor.

Note Note

End of the note.

Prerequisites

You are logged on to the database as a database user.

Procedure

  1. In the context menu of the table, choose Content.

    The data records are displayed.

    To display only data records that fulfill specific criteria, choose Filter in the context menu. You can enter your filter criterion in the first column of a row.

    More information: SQL Reference Manual, Predicate (predicate)

  2. To switch to edit mode, select Edit in the context menu of the table editor.

Inserting Data Records
Prerequisites

You have the INSERT privilege for the table.

More information: SQL Reference Manual, Privilege Specification (priv_spec)

Procedure
  1. In the context menu of the table editor, choose New Row.

  2. Enter the values.

    To insert the LOB value, choose   Import Cell From...   File   in the context menu of the cell to which you want to import the changed value.

  3. In the context menu of the new data record, choose Insert Row.

Updating Data Records
Prerequisites

You have the UPDATE privilege for each table column.

Procedure

To update (change) a data record, overwrite the old values.

Note Note

The system makes all changes in the database immediately.

End of the note.

To change an LOB value, proceed as follows:

  1. In the context menu of the LOB value, choose   Export Cell To...   File  .

  2. Change the LOB value using a suitable editor.

  3. Choose   Import Cell From...   File   in the context menu of the cell to which you want to import the changed value.

Deleting Data Records
Prerequisites

You have the DELETE privilege for the table.

Procedure

In the context menu of the data record, choose Delete Selected Row.

Note Note

The system deletes the data record from the database immediately.

End of the note.
Exiting Edit Mode

In the context menu of the table editor, deselect Edit.

More Information

Table Editor

SQL Reference Manual, Data Manipulation