Creating SQL Objects › Creating a View

Creating a View

Use the CREATE VIEW statement to define a view (a derived table) of one or more tables or views. Enter the CREATE VIEW statement in the numbered area of an EDIT Source Member Panel. See How to Submit SQL Statements for the steps to obtain the panel and an explanation of the fields on the panel. See CREATE VIEW for the syntax of the statement.

The following restrictions apply to the tables on which a view is derived.

SQL Accessible Tables

Since a view is derived from specified columns in a table or tables, the table or tables must be defined in the CA Datacom Datadictionary and be SQL accessible. You can place the CREATE VIEW statement(s) after the the CREATE TABLE statement(s) in a single source member.

Same Security Type

All of the tables and views specified with the CREATE VIEW statement must be in databases secured under the same security model, either the CA Datacom/DB External Security Model or the SQL Security Model. See the CA Datacom Security Reference Guide for more information about security models.

Remote Tables

A complete duplicate definition of a remote table in CA Datacom Datadictionary is required for SQL access. No version control enforcement is available to ensure that remote definitions are synchronized with the local active definitions.