Create Sequence
It describes how to create the Sequence object with Gui Operation.
Execute Sequence Folder > Context Menu > Create Sequence to create the Function objects through the PSM Editor.
The details of the Sequence can be set through each option. SQL applied to the settings is shown in the bottom SQL area.
Schema
Select the schema for which the Sequence will be created.
Default: Schema in the currently selected Sequence folder
Sequence Name
Enter the name of the Sequence to be created.
Start With
Start With
Set the starting value of the Sequence.
Default: MINVALUE if the INCREMENT value is positive, MAXVALUE if the INCREMENT value is negative
Increment
Specifies the interval between increments of the IncrementSequence.
If positive, the Sequence value is incremented; if negative, the Sequence value is decremented.
Default: 1
Min Value
Min Sets the minimum value that the ValueSequence can have.
Max Value
Max Sets the maximum value that the ValueSequence can have.
Cache
Specifies whether to store the value in the Cache for the Cache Size.
Cache Size can be set when Cache is selected, and defaults to 20.
Cycle
Specifies whether to continue generating Sequence values after the MaxValue or MinValue is reached.
Default: No Cycle
Order
Specifies whether to preserve the order of Sequences issued between nodes in a cluster environment.
Default: No Order
After completing the detailed settings for each option, click the [Create button] to create a Sequence object with the settings.
Last updated