Physical Modeling › DB2 z/OS Property Editors › Define a DB2 z/OS Sequence

Define a DB2 z/OS Sequence

Use the Sequence editor to define the parameters for a DB2 sequence.

To define a DB2 for z/OS sequence

1. Right-click a Sequence in the Model Explorer and select Properties.

   The DB2 for z/OS Sequence Editor opens.

2. Select a sequence and work with the following options:

   Note: Click New on the toolbar to create a sequence. Use the Enter filter text text box to filter a large list of names to locate the one you want to work with.

   Name

   Specifies the name of the sequence.

   Schema

   Specifies the default schema for the sequence. Select a schema from the drop-down list.

   Physical Data Type

   Specifies the physical data type for the sequence. Select a data type from the drop-down list.

   Generate

   Specifies whether or not to generate DDL for this object during Forward Engineering.

3. Work with the following fields on the General tab:

   Starting Value

   Specifies the first value for the sequence.

   Increment By

   Specifies the interval between consecutive values of the sequence.

   Specify Minimum Value/Minimum Value

   Specifies if you want to indicate the minimum value for the sequence. When you select True from the drop-down list, a second field appears, where you can indicate the value.

   Specify Maximum Value/Maximum Value

   Specifies if you want to indicate the maximum value for the sequence. When you select True from the drop-down list, a second field appears, where you can indicate the value.

   Cycle Values

   Specifies that the value of a sequence that reaches its maximum or minimum value to generate its respective minimum value or maximum value on the following NEXT VALUE expression. You can select Cycle or No Cycle.

   Cache Values

   Specifies the maximum number of sequence values that the database manager generates and stores in memory. When you select True from the drop-down list, the field Cache Capacity appears, where you can indicate the value.

   Order Values

   Specifies whether or not the sequence numbers must be generated in order of request.

4. Click the Permission tab and grant permissions to users or roles on the selected sequence.
5. (Optional) Click the Comment tab and enter any comments you want associated with the sequence.
6. (Optional) Click the UDP tab to work with user-defined properties for the sequence.
7. (Optional) Click the Notes tab to view history information and view or edit user notes.
8. Click Close.

   The DB2 for z/OS Sequence Editor closes.

More information:

Add a Comment in a Property Editor

Add a UDP in a Physical Property Editor