Sequence Alter Option

You can alter a sequence. All changes that need to be propagated to dependent objects are incorporated into alterations.
carcudb2
You can alter a sequence. All changes that need to be propagated to dependent objects are incorporated into alterations.
Follow these steps:
  1. Perform the following actions on the CA RC/Update Main Menu:
    • Type
      A
      in the Option field of the main header.
    • Type
      SQ
      in the Object field of the main header.
    • Specify a sequence name in the Item Name field.
    • Specify a creator name in the Creator field. If you do not specify a sequence name or creator name, a selection list appears, from which you can choose.
    Press Enter.
    The Sequence Alter panel appears.
  2. Change any Sequence Dynamics definition fields as needed, and then press the END key.
    The Alter Confirmation panel or Alteration Analysis panel (for RC/Alter) appears, depending on whether changes can be made without dropping and re-creating the object.
  3. Continue the process as follows, depending on the panel presented:
    • Respond on the Alter Confirmation panel by performing
      one
      of the following actions:
      • Press Enter to execute the DDL online through the Batch Processor.
      • Enter
        E
        in the command line to edit the generated DDL.
      • Press the END key to return to the alter panel.
    • Respond on the Alteration Analysis panel by typing
      O
      or
      B
      for Execution Mode, completing other fields as needed, then pressing Enter.
      Based on your selections on the Alteration Analysis panel, you can invoke the Analysis Options panel, Recovery Options panel, or Batch JCL Specification panel (if batch mode is specified). 
    Your session continues, depending on your choice.