SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
2-146
Considerations for CREATE VIEW
Any Guardian file name you specify must match the designated schema
subvolume name for the schema in which the object is being created.
Otherwise, NonStop SQL/MX returns an error.
AS query-expr
specifies the columns for the view and sets the selection criteria that determines
the rows that make up the view. This query-expr cannot contain non-ISO88591
string literals. For the syntax description of query-expr, see SELECT Statement
on page 2-255.
WITH [CASCADED] CHECK OPTION
specifies that no row can be inserted or updated in the database through the view
unless the row satisfies the view definition—that is, the search condition in the
WHERE clause of the query expression must evaluate to TRUE for any row that is
inserted or updated.
If you omit this option, a newly inserted row or an updated row need not satisfy the
view definition, which means that such a row can be inserted or updated in the
table but does not appear in the view. This check is performed each time a row is
inserted or updated.
WITH CHECK OPTION does not affect the query expression; rows must always
satisfy the view definition. CASCADED is an optional keyword; WITH CHECK
OPTION has the same effect.
Considerations for CREATE VIEW
You cannot create an SQL/MX view that references an SQL/MP table or an SQL/MP
alias.
VIEW SIMILARITY CHECK
Starting with SQL/MX Release 3.2, the CREATE VIEW statement provides optional
syntax to enable or disable Similarity Check for a view. By specifying ENABLE