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
You can also change data directly with an SQL statement.
More information: Working with SQL Statements: Overview
You can import data.
More information: Importing Data or the Database Catalog
You are logged on to the database as a database user.
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)
To switch to edit mode, select Edit in the context menu of the table editor.
You have the INSERT privilege for the table.
More information: SQL Reference Manual, Privilege Specification (priv_spec)
In the context menu of the table editor, choose New Row.
Enter the values.
To insert the LOB value, choose
in the context menu of the cell to which you want to import the changed value.In the context menu of the new data record, choose Insert Row.
You have the UPDATE privilege for each table column.
To update (change) a data record, overwrite the old values.
Note
The system makes all changes in the database immediately.
To change an LOB value, proceed as follows:
In the context menu of the LOB value, choose
.Change the LOB value using a suitable editor.
Choose
in the context menu of the cell to which you want to import the changed value.You have the DELETE privilege for the table.
In the context menu of the data record, choose Delete Selected Row.
Note
The system deletes the data record from the database immediately.
In the context menu of the table editor, deselect Edit.