Table data editor overview

You can use the table data editor to retrieve and display the data from the database. The table data editor can be opened in read-only mode or in edit mode.

Read-only mode lets you view the data and prevents you from making any inadvertent changes to the data.

Edit mode lets you edit the data and save the changes to the database. Edit mode is suited for selectively viewing the data and making minor updates for repairs or testing purposes. Typically, you want to use the table data editor in edit mode to change a few rows during a short window of time, while no other applications are updating the data. When you save the changes, either all or none of the changes to the data are committed to the database.

Some types of objects can be opened only in read-only mode; other types of objects can be opened either in read-only mode or in edit mode. The following table indicates the modes that are supported for different types of objects, where an X indicates support:
Table 1. Table data editor support for viewing and editing data
Data source Version Object View data only Edit data
DB2® for Linux, UNIX, and Windows Version 9.1 Tables X -
Views X -
Aliases X -
Materialized query tables (user- and system-maintained) X -
Nicknames X -
Version 9.5 and later Tables X X
Views X X
Aliases X X
Materialized query tables (user-maintained) X X
Materialized query tables (system-maintained) X -
Nicknames X -
DB2 for z/OS® Version 9 and later Tables X X
Views X X
Aliases X -
Materialized query tables (user-maintained) X -
Materialized query tables (system-maintained) X -
Synonyms X -
Restriction: If any of these objects have a column that has a user-defined structured data type, you cannot browse or edit the data.

You can change the maximum number of rows that the table data editor retrieves and displays by using the Max Row Count preference (Window > Preferences > Data Management > SQL Development > SQL Results View Options).

Attention: Retrieving a large amount of data can negatively affect the memory usage and performance of the product.

The table data editor also supports filtering. You can set filtering conditions to display only the columns and rows that you are most interested in.

Tip: As you work with the table data editor, the editor is automatically closed if the database model in the Eclipse workbench undergoes a change that might negatively affect the future functioning of the editor. A message is displayed to explain the reason for closing the table data editor. You can open the table data editor again after the operations that caused the database model to change are finished.

Feedback