Home
Working with FM/Db2
Viewing and changing Db2® data
To view the contents of a Db2® table or view, use the FM/Db2 View Utility (option 1), the FM/Db2 Edit Utility (option 2), or the FM/Db2 Browse Utility (option B).
Changing data
"Read-only" views, non-updateable columns
Materialized query tables

Materialized query tables

If you want to edit objects of type, "MATERIALIZED QUERY", then the object must be defined with the DEFERRED refresh mode and with the MAINTAINED BY USER option. If these criteria are not satisfied, the user cannot edit the object, and the VIEW/EDIT session is substituted with a BROWSE session. A message is issued informing the user that the VIEW/EDIT session type is not supported for the object with the current refresh mode and maintenance settings.

Related tasks

ROWID columns

To add feedback about this topic, select the following checkbox:

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners Four, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box. Note: To report a problem or question about the product software, do not use this form. Instead, go to the HCL Software Support site. Personal data should not be shared in this comment box. See our Privacy Statement to understand how personal data is used.