SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Metadata Tables
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
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
number Column Name Data Type Description
*1 OBJECT_UID LARGEINT UID of Sequence Genera-
tor object
2 SG_TYPE CHAR(2) Type of Sequence Gener-
ator:
'I' for Internal Sequence
Generator
'E' for External Sequence
Generator
3 START_VALUE NUMERIC(128,
0)
Start value for the
Sequence Generator. The
data type is changed in
SQL/MX Release 3.2. In
earlier versions, the data
type is LARGEINT
4 INCREMENT NUMERIC(128,
0)
Increment for the
Sequence Generator. The
data type is changed in
SQL/MX Release 3.2. In
earlier versions, the data
type is LARGEINT
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.
The data type is changed
in SQL/MX Release 3.2.
In earlier versions, the
data type is LARGEINT
8 MIN_VALUE NUMERIC(128,
0)
The minimum value for
the Sequence Genera-
tor.The data type is
changed in SQL/MX
Release 3.2. In earlier
versions, the data type is
LARGEINT