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-24
Syntax Description of ALTER TABLE
ATTRIBUTE[S] attribute [,attribute ]...
changes the values of file attributes for the table and its dependent indexes. You
can separate attributes with either a space or a comma. File attributes you can
specify are:
Unlike NonStop SQL/MP’s form of this statement, SQL/MX’s ALTER TABLE
statement has no PARTONLY clause. When you supply a new value for attributes,
ALTER TABLE modifies the value of the attribute on all partitions of the table. For
more detail, see the entry for a specific attribute.
basic-sequence-generator-option
INCREMENT BY signed-numeric-literal
See INCREMENT BY signed-numeric-literal in Syntax Description of
CREATE TABLE on page 2-99.
MAXVALUE signed-numeric-literal
See MAXVALUE signed-numeric-literal in Syntax Description of
CREATE TABLE on page 2-99. NO MAXVALUE is not a valid specification for
ALTER TABLE ALTER COLUMN.
recalibrate-option
recalibrates the CURRENT_VALUE of the internal Sequence Generator. This might
be necessary after a FASTCOPY, DUP or an IMPORT operation. There are three
ways to recalibrate:

Recalibrate based on the INCREMENT BY internal sequence generator option
and the maximum value of the IDENTITY column in the base table.

Recalibrate to a user-specified value with a SELECT to obtain the maximum
value of the IDENTITY column from the base table.

Recalibrate to a user-specified value without performing a SELECT of the
IDENTITY column maximum value.
See Recalibrating the Sequence Generator of an IDENTITY column on page 2-31
for more details.
ALLOCATE/DEALLOCATE
on page 8-2
Controls amount of disk space allocated.
AUDITCOMPRESS on
page 8-3
Controls whether unchanged columns are included
in audit records.
CLEARONPURGE on
page 8-5
Controls disk erasure when table is dropped.
MAXEXTENTS on
page 8-7
Controls maximum disk space to be allocated.