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-143
CREATE VIEW Statement
CREATE VIEW view
[(column-name [heading] [,column-name [heading]]...)]
[ {ENABLE | DISABLE} SIMILARITY CHECK ]
[LOCATION [\node.]$volume[.subvolume.filename]]
AS query-expr
[WITH [CASCADED] CHECK OPTION]
heading is:
HEADING 'heading-string' | NO HEADING
query-expr is:
non-join-query-expr | joined-table
non-join-query-expr is:
non-join-query-primary | query-expr UNION [ALL] query-term
query-term is:
non-join-query-primary | joined-table
non-join-query-primary is:
simple-table | (non-join-query-expr)
joined-table is:
table-ref [NATURAL] [join-type] JOIN table-ref [join-spec]
join-type is:
INNER | LEFT [OUTER] | RIGHT [OUTER]
join-spec is:
ON condition
simple-table is:
VALUES (row-value-const) [,(row-value-const)]...
| TABLE table
| SELECT [ALL | DISTINCT] select-list
FROM table-ref [,table-ref]...
[WHERE search-condition]
[SAMPLE sampling-method]
[TRANSPOSE transpose-set [transpose-set]...
[KEY BY key-colname]]...
[SEQUENCE BY colname [ASC[ENDING] | DESC[ENDING]]
[,colname [ASC[ENDING] | DESC[ENDING]]]...]
[GROUP BY {colname | colnum} [,{colname |
colnum}]...]
[HAVING search-condition]
row-value-const is:
row-subquery | expression [,expression]...