SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Statements

HP NonStop SQL/MX Reference Manual—540440-003

2-8

Considerations for ALTER INDEX

You cannot use ALTER INDEX to change a partition’s name.

Authorization and Availability Requirements

To alter an index, you must own its schema or be the super ID.

All partitions of the index must be available when ALTER INDEX executes. The

appropriate metadata tables must also be available.

Examples of ALTER INDEX

•

This example changes the maximum number of extents to 760:

ALTER INDEX xempname ATTRIBUTE MAXEXTENTS 760

ALTER SQLMP ALIAS Statement

Considerations for ALTER SQLMP ALIAS

Examples of ALTER SQLMP ALIAS

The ALTER SQLMP ALIAS statement changes the physical name of an SQL/MP table

to which an existing alias is mapped.

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 a 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.

ALTER SQLMP ALIAS catalog.schema.object

[\node.]$volume.subvol.filename