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.
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 | - |
You can change the maximum number of rows that the table data editor retrieves and displays by using the Max Row Count preference (
).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.