SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
2-156
Syntax Description of CREATE VIEW
SQL/MP, which 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.
ENABLE SIMILARITY CHECK
enables Similarity Check for the view.
DISABLE SIMILARITY CHECK
disables Similarity Check for the view.
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 volume named in the =_DEFAULTS define if none is specified).
If you do not specify a LOCATION clause and your system does not have a
value for the DDL_DEFAULT_LOCATIONS default (either in your environment
or at the system level) and your environment does not have a =_DEFAULTS
value, the CREATE statement will fail with an error.
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 long and must end with the digits “00” (zero zero).
When you specify the subvolume, the file-name must be specified with it.
The subvolume and file-name are optional.