Change a sequence

To change a sequence:

  1. In the System i Navigator window, expand the system you want to use.
  2. Expand Databases and the database that you want to work with.
  3. Expand Schemas and the schema in which your sequence exists.
  4. Right-click your sequence, and select Define. You can change all the information on this dialog except for the sequence name and the schema.
  5. Specify a increment, starting value, minimum value, maximum value, and value to cache.
  6. If you want values to cycle after reaching their minimum or maximum, check the Cycle values when the minimum or maximum value is reached box.
  7. If you want to generate the values in order, check the Generate values in the order requested box.
  8. Specify a description in the Text field (optional).
  9. Click OK.

You can view the SQL used to create this object by select Show SQL. This action launches Run SQL Scripts. You can then choose to run the SQL from the Run SQL Scripts window. However, if you edit the SQL in the Run SQL Scripts window, the changes are not reflected back to the dialog. Additionally, if you create the object from the Run SQL Scripts window and then click OK on the dialog, you will receive an error.