Altering a sequence generator
Procedure
- Log on to the NonStop SQL/MX Database Manager.
- In the navigation tree, navigate to the Schemas folder by expanding Database > My Systems > Catalogs > Schemas.
- Expand Sequences folder (left pane) or click the Sequences tab (right pane), and select the sequence generator you want to alter.
-
Right-click and select
Alter Sequence.
The Alter Sequence dialog box appears.
-
Select the check box corresponding to an option to enable it.
You can alter any of the following attributes:This attribute resets the current value with the user specified value. If this option is selected, the other options cannot be selected. Restart With is available only for alter sequence operation.
- Increment By
- Min Value
- Max Value
- Cycle
- Restart With
For more information, see Sequence generator attributes.
-
Click
OK.
NOTE:
Altering a sequence generator attribute changes the redefinition timestamp for the sequence generator. As a result, the similarity checks fail during runtime for applications that use altered sequence generators, and therefore applications are recompiled. To avoid this, HPE recommends you to recompile all the applications using the sequence generator after altering the attributes.