Read-only views

A view is read-only if it is not deletable, updatable, or insertable. A view can be read-only if it is a view that does not comply with at least one of the rules for deletable views.

The READONLY column in the SYSCAT.VIEWS catalog view indicates a view is read-only (R).

The following example does not show a deletable view as it uses the DISTINCT clause and the SQL statement involves more than one table:

    CREATE VIEW read_only_view
      (name, phone, address)
    AS
    SELECT DISTINCT viewname, viewphone, viewaddress
    FROM employee.history adam, employer.dept sales
    WHERE adam.id = sales.id