Previous Topic: CREATE TRIGGER/RULENext Topic: Privileges

SQL Statements › CREATE VIEW

CREATE VIEW

In the following table, YES indicates a valid execution method for this statement.

This SQL statement can be executed in the following ways:

Through the CA Datacom Datadictionary Interactive SQL Service Facility (interactive)

In an application program prepared using a CA Datacom/DB SQL Preprocessor (embedded)

By using CA Dataquery (SQL & Batch Modes)

CREATE VIEW

YES

YES

YES

To learn about using SQL keywords in CA Dataquery, see the CA Dataquery User Guide.

For information about the access rights required to execute this statement, see the CA Datacom/DB Database and System Administration Guide.

The CREATE VIEW statement creates a view (derived table) of one or more tables or views.

When a CREATE VIEW statement successfully executes, a VIEW entity-occurrence is defined in CA Datacom Datadictionary in PROD status.

All of the tables and views specified in the CREATE VIEW statement must be in databases of the same security type, that is to say, 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.