SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Metadata Tables
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
10-28
SEQUENCE_GENERATORS Table
SEQUENCE_GENERATORS Table
SEQUENCE_GENERATORS is a metadata table in
DEFINITION_SCHEMA_VERSION_vernum that contains sequence generator
attributes.
Column Name Data Type Description
*1 OBJECT_UID LARGEINT UID of sequence generator object
2 SG_TYPE CHAR(2) Sequence generator type:
I - Internal sequence generator
E - External sequence generator
**3 START_VALUE NUMERIC(128,0) Sequence generator start value
**4 INCREMENT NUMERIC(128,0) Increment value for the sequence
generator
5 SQL_DATA_TYPE CHAR(18) SQL data type, same as for the
COLS table
6 FS_DATA_TYPE INTEGER File system data type, same as
for the COLS table
**7 MAX_VALUE NUMERIC(128,0) The maximum value for the
sequence generator
**8 MIN_VALUE NUMERIC(128,0) The minimum value for the
sequence generator
9 CYCLE_OPTION CHAR(2) Y/N indication if the CYCLE
option is used
10 CACHE NUMERIC(128,0) Reserved for future use
11 SG_ORDER CHAR(2) Reserved for future use
12 EXTENDED_PRECISION INTEGER Numeric precision, used inter-
nally when generating sequence
numbers. The possible values are
in the range 18-28
* Indicates primary key
** In versions prior to
SQL/MX Release 3.2, the
data type is LARGEINT