Adding Custom Sequences
Custom sequences are defined using the Sequences tag. The table below describes the elements in this tag.
|
Attribute
|
Default Value
|
Possible Values
|
Required?
|
Description
|
|---|---|---|---|---|
|
Sequence
|
Definition for a single sequence
|
Yes
|
Details for defining a given sequence.
|
|
|
SequenceName
|
Name of the sequence
|
Yes
|
Name of the sequence to be added.
Example: <SequenceName>partSeq</SequenceName>
|
|
|
StartingNumber
|
1
|
For an ascending sequence, specify a value greater than MinValue. For a descending sequence, specify a value less than MaxValue.
|
No
|
Number that the sequence should begin with.
|
|
IncrementBy
|
1
|
Positive or negative integer, but no 0.
|
No
|
Interval between sequence numbers.
|
|
MinValue
|
1
|
Must be less than or equal to StartingNumber, and less than MaxValue.
|
No
|
Minimum value for the sequence.
|
|
MaxValue
|
9999999999999999999999999999
|
Must be greater than or equal to StartingNumber, and greater than MinValue.
|
No
|
Maximum value for the sequence.
|
|
Cache
|
If left blank, the size is set to the default provided by the database.
|
Minimum value for this parameter is 2.
|
No
|
Number of sequence values that the database should cache for faster access.
|
|
CycleValues
|
false
|
true
false
|
No
|
true: Generate values even after the sequence has reached its maximum or minimum value.
false: Do not generate values after the sequence has reached its maximum or minimum value.
|
 |
Only Oracle database supports custom sequences.
|