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-10
Examples of ALTER INDEX
For information on effects of rename option on RDF, see Effects on RDF on page 2-33.
Examples of ALTER INDEX

This example changes the maximum number of extents to 760:
ALTER INDEX xempname ATTRIBUTE MAXEXTENTS 760

The following command renames the index, CAT.SCH.I1 to I2:
ALTER INDEX CAT.SCH.I1 RENAME TO I2;
The new ANSI name of the index, I2 is not fully qualified since the index continues
to remain in the same catalog and schema as I1. After the index is renamed, the
fully qualified name of the index is CAT.SCH.I2.
ALTER SQLMP ALIAS Statement
Considerations for ALTER SQLMP ALIAS
Examples of ALTER SQLMP ALIAS
The ALTER SQLMP ALIAS statement maps an existing alias to a different SQL/MP table.
ALTER SQLMP ALIAS is an SQL/MX extension.
Syntax Description of ALTER SQLMP ALIAS
catalog.schema.object
is the alias name of an SQL/MP table or view. catalog and schema denote
ANSI-defined catalog and schema, and object is a simple name for the table or
view. If any part of the name is an SQL/MX reserved word, you must delimit it by
enclosing it in double quotes. For example: mycat."sql".myview.
[\node.]$volume.subvol.filename
is the fully qualified Guardian physical name of an SQL/MP table or view.
In this four-part name, \node is the name of a node of a NonStop server, $volume
is the name of a disk volume, subvol is the name of a subvolume, and filename
is the name of an SQL/MP table or view. if any of the four parts of the name is an
SQL/MX reserved word, you must delimit it by enclosing it in double quotes. Such
delimited parts are not case-sensitive. For example: $myvol."join".mytab.
If you do not specify \node, the default is the Guardian node named in the
=_DEFAULTS define.
ALTER SQLMP ALIAS catalog.schema.object
[\node.]$volume.subvol.filename