Sequence properties

Properties for IBM® data server sequence objects

For more information about specific syntax, see the reference information that is included with each database product. Syntax definitions for some database vendors or versions might differ from the following descriptions.

General page
Property Description
Name Specifies a name for the object.
Label Specifies a label that is displayed in visual diagrams.
Data type Specifies a data type for the sequence value.
Type page
Property Description
Start value Specifies a value for the START WITH clause.
Increment Specifies a value for the INCREMENT BY clause.
Minimum Specifies a value for the MINVALUE clause.
Maximum Specifies a value for the MAXVALUE clause.
Cycle Specifies the CYCLE option. Specifies whether the sequence should continue to generate values after reaching either its maximum or minimum value.
Cache Specifies the CACHE option. Specifies whether to keep some preallocated values in memory for faster access. This is a performance and tuning option.

If you select this check box, specify the maximum number of sequence values that are preallocated and kept in memory. The minimum value is 2. The default value is 20.

Order Specifies the ORDER option. Specifies whether the sequence numbers must be generated in order of request.
Documentation page
Specifies user-supplied information about the object.
Annotation page (in edit mode only)
Add, modify, or delete properties.

Feedback