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

 

Changing data in the database means that you add a data record to a table, update a data record, or delete a data record. You can use the table editor for this.

Note Note

End of the note.

Prerequisites

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

Procedure

  1. In the explorer tree, select the table in which you want to change data.

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

    The data records are displayed.

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

    More information: SQL Reference Manual, Predicate (predicate)

  3. 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 applies all changes 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 immediately deletes the data record from the database.

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