Altering a sequence generator

Procedure

  1. Log on to the NonStop SQL/MX Database Manager.
  2. In the navigation tree, navigate to the Schemas folder by expanding Database > My Systems > Catalogs > Schemas.
  3. Expand Sequences folder (left pane) or click the Sequences tab (right pane), and select the sequence generator you want to alter.
  4. Right-click and select Alter Sequence.

    The Alter Sequence dialog box appears.

    Alter Sequence dialog box
  5. 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.

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