(Optional) See DATACOM VIEWs.
The unqualified or qualified name of the view. This name, including the implicit or explicit qualifier, must not name a table, view or synonym already described in the CA Datacom Datadictionary.
If you specify SQLMODE=ANSI or SQLMODE=FIPS in the Preprocessor options, the view name can be 1 to 18 characters in length.
If you specify SQLMODE=DATACOM for extended mode in the Preprocessor options, the view name can be 1 to 32 characters in length.
The qualified form is the name preceded by an authorization ID and a period, for example, auth-id.view-name.
If you qualify the view-name, the qualifier designates the schema of the view. If you do not qualify the view-name, the default authorization ID is used as the qualifier.
If the CA Datacom/DB Security Facility is installed, the creator of the view is automatically granted the SELECT privilege on the view, and any other privilege that applies to a view and is a privilege that the creator has on the tables or views identified in the FROM clause of the SELECT statement. A privilege acquired by the creator is grantable only if the privilege from which it is derived is grantable by the creator.
A list of one or more names for columns in the view. The column names must be separated by commas and the list must be enclosed in parentheses.
If you specify SQLMODE=ANSI or SQLMODE=FIPS in the Preprocessor options, the column name can be 1 to 18 characters in length.
If you specify SQLMODE=DATACOM for extended mode in the Preprocessor options, the column name can be 1 to 32 characters in length.
If you do not give other names to the columns, the columns of the view have the same names as the columns of the result table of the SELECT statement.
If the result of the SELECT statement has duplicate column names, or a column derived from a function, literal, or arithmetic expression, you must give names to all the columns. Give a name for each column and do not use the same name more than once.
The subselect defines the view. At any time, the view consists of the rows that result if the SELECT statement is executed.
The subselect must be the subselect form of a SELECT statement that does not reference host variables. See Subselect for the subselect syntax diagram and information about the subselect parameters.
Specifies that all inserts and updates against this view are checked to ensure that the newly inserted or updated row satisfies the view definition.
For example, if you use the view to insert a row, the row can be inserted only if you can also view it using this view, that is to say, the data being inserted must be within the bounds specified in the view's definition.
The WITH CHECK OPTION can be specified only if the view is updateable and the view definition does not include a nested subquery.
See Example 3 for a view definition using the WITH CHECK OPTION.
|
Copyright © 2014 CA.
All rights reserved.
|
|