SQL/MX 3.2 Query Guide (H06.25+, J06.14+)

SQL/MX Operators
HP NonStop SQL/MX Release 3.2 Query Guide—663851-002
7-65
SEQUENCEGENERATOR Operator
SEQUENCEGENERATOR Operator
The SEQUENCEGENERATOR operator provides access to the sequence generator
table to get the next value or the next block of values. It temporarily suspends the
current user transaction, and starts and commits a new transaction to access the
sequence generator table.
The SEQUENCEGENERATOR operator is isolated into its own ESP by the
ESP_ACCESS operator.
The description field for the operator contains the following:
Token Followed by ... Data Type
max_card_est Cardinality estimate for this operator. integer
fragment_id A sequential number assigned to the fragment.
0 is the master executor and 1 is reserved for
the EXPLAIN plan. Numbers 2 to n will be ESP
or DAM fragments.
integer
parent_flag The fragment_id for the parent of the current
fragment. The value is (none) for the master
executor.
integer
fragment_type ESP. text
sg_start_with_option The sequence generator option that specifies
the start value of the cycle.
int64
sg_increment_option The INCREMENT-BY option of the sequence
generator. The next value is obtained by
adding this value to current value.
int64
sg_maximum_option The sequence generator option that specifies
the highest value in the cycle.
int64
sg_minimum_option The sequence generator option that specifies
the lowest value in the cycle.
int64
sg_datatype The sequence generator data type. int64
sg_cycle_option The sequence generator option that specifies
whether the sequence generator values can
be cycled. The option values are CYCLE or
NO CYCLE.
text
sg_cache The user defined sequence generator cache
value. The default is 0. If the value is greater
than 0, each request gets the user specified
number of values for the cache.
int64
TP663851.fm Page 65 Thursday, August 2, 2012 4:47 PM