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-13
Examples of ALTER INDEX
For information on effects of rename option on RDF, see Effects on RDF on page 2-40.
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 SEQUENCE Statement
Considerations for ALTER SEQUENCE
Examples of ALTER SEQUENCE
The ALTER SEQUENCE statement alters the ANSI name, INCREMENT BY value,
MAXVALUE, MINVALUE and CYCLE attributes of a sequence generator.
Altering a sequence generator attribute changes the redefinition timestamp for the
sequence generator. As a result, the runtime similarity checks fail for applications using
altered sequence generators and the applications are recompiled. To avoid this runtime