Previous Topic: For SQL AccessNext Topic: For a Sequential File

Introduction › Dataview Menu › Readonly Classification

Readonly Classification

When a dataview for SQL access is cataloged, CA Ideal classifies it as read‑only when it refers to a view created with DISTINCT, GROUP BY/HAVING, or a join. A column in a table marked as UPDATE=NO in the SYSCOLUMNS table of the DB2 catalog or created in a view with an SQL function results in a read‑only column in the dataview.