Results of Defining Structures Using SQL Statements › CREATE VIEW Statement

CREATE VIEW Statement

CREATE VIEW view-name

Creates a view. The following are the significant VIEW entity-occurrence attributes defined:

• AUTHID= The supplied or default schema (authorization ID).
• ENTITY-NAME= An internally generated unique name consisting of the schema (the AUTHID) followed by a hyphen and the name specified in the CREATE statement (the name must be unique— see the Occurrence Names Created from SQL Names section in the CA Datacom Datadictionary User Guide for details on actions taken by CA Datacom Datadictionary to create unique names).
• FIPS= Indicates if the procedure is valid in FIPS processing. Y indicates yes, N indicates no, and S indicates no because of syntax.
• LENGTH= The sum of the lengths of all columns included in the view.
• SQLNAME= The view-name specified in the CREATE VIEW statement.

column-name

Creates a column (FIELD entity-occurrence). See the CREATE TABLE column-name statement.

AS subselect

Creates a relationship between the view and the table whose columns make up the view.

WITH CHECK OPTION

Creates a domain constraint. The following are the significant CONSTRAINT entity-occurrence attributes defined:

• AUTHID= The schema (authorization ID) associated with the table.
• ENTITY-NAME= An internally generated unique name consisting of the schema (the AUTHID used when creating the table) followed by a hyphen and the SQLNAME.
• SQLNAME= The view-name provided in the CREATE VIEW statement.