SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—523725-004
2-107
Syntax Description of CREATE VIEW
does not display anything for a heading in a SELECT statement if the heading
is specified as HEADING ‘’.
The HEADING clause is an SQL/MX extension.
LOCATION [\node.]$volume[.subvolume.filename]
specifies a node and volume for the label of the view.
node
is the name of a node on the Expand network.
For Guardian files representing a table or index partition or a view label, node
can be any node from which the object's catalog is visible.
volume
is the name of an audited, non-SMF DAM volume on the specified node (or the
Guardian system named in the =_DEFAULTS define if none is specified).
subvolume
is the designated schema subvolume for the schema in which the index is
being created.
Follow these guidelines when using SQL/MX subvolume names:
•
The name must begin with the letters ZSD, followed by a letter, not a digit
(for example, ZSDa, not ZSD2).
•
The name must be exactly eight characters long.
file-name
is an optional Guardian file name. file-name names must be eight
characters in length and must end with the digits “00” (zero zero.)
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-178.
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