Renaming 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 the Sequences folder (left pane) or click the Sequences tab (right pane), and select the sequence generator you want to rename.
  4. Right-click and select Rename Sequence.

    The Rename Sequence dialog box appears.

  5. Enter the name for the sequence generator in the New Sequence Name field and click OK.
    NOTE:

    Renaming a sequence generator changes the ANSI name and 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 renaming the sequence generator.