Editing database tables using special registers

You can change data in database tables using special registers. A special register is a storage area that is defined for an application process by Db2® and is used to store information for the reference. A reference to a special register is a reference to a value provided by the current server. The list of available special registers depends on the version of the database.

Before you begin

Open the database table that you want to edit on the Results tab of the Table Editor.

About this task

You can edit a database table by using special registers. Special registers are supported for the following databases: Db2, Snowflake, , MySQL, Informix, and Oracle.

Procedure

  1. Enter a special register to a table cell, which value you want to edit.
  2. Commit the changes to replace the special registers that you entered by the values of the special registers. See the Working with database tables topic for the detailed information on editing, inserting data, and committing changes to the tables.
    Note: If you use the special register to change the column value in one of the duplicate rows of the table, the column values are updated in all duplicate rows.

    The database casts the data type of the special register value to the column data type.