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-14
ALTER SEQUENCE Statement
recompilation overhead, HP recommends recompiling all the applications using the
sequence generator after altering the attributes.
ALTER SEQUENCE sequence alter-actions
alter-actions is:
{ sequence-generator-options
| sequence-generator-restart-with
| RENAME rename-clause
}
sequence-generator-options is:
{ sequence-generator-option [sequence-generator-option
…]
}
sequence-generator-option is:
{ sequence-generator-increment-by-option
| sequence-generator-maxvalue-option
| sequence-generator-minvalue-option
| sequence-generator-cycle-option
}
sequence-generator-increment-by-option is:
INCREMENT BY sequence-generator-numeric-value
sequence-generator-maxvalue-option is:
{ MAXVALUE sequence-generator-numeric-value
| NOMAXVALUE
| NO MAXVALUE
}
sequence-generator-minvalue-option is:
{ MINVALUE sequence-generator-numeric-value
| NOMINVALUE
| NO MINVALUE
}
sequence-generator-cycle-option is:
{ CYCLE
| NOCYCLE
| NO CYCLE
}
sequence-generator-restart-with is:
RESTART WITH sequence-generator-numeric-value
sequence-generator-numeric-value is:
< [+|-] numeric-literal >
rename-clause is:
TO < new-sequence-name >