SQL Read-Only

SQL read-only tables can be defined by specifying the SQL-INTENT attribute-type as R in CA Datacom Datadictionary batch or online.

In a table defined as SQL read-only, using SQL Data Definition Language (DDL) statements to attempt to insert new rows, update existing rows, or delete existing rows is not allowed. Attempts to do so result in an error message.

Note: For more information on SQL read-only tables, see the CA Datacom/DB Database and System Administration Guide, the CA Datacom Datadictionary Batch Reference Guide, and the CA Datacom Datadictionary Attribute Reference Guide.