SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Metadata Tables
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-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.
SG_USAGE Table
SG_USAGE is a metadata table in DEFINITION_SCHEMA_VERSION_vernum that
represents the usage of Sequence Generator objects by other objects.
Column number Column Name Data Type Description
*1 OBJECT_UID LARGEINT UID of SG object
2 SG_TYPE CHAR(2) Type of SG:
'I' for internal SG
'E' for external SG
3 START_VALUE LARGEINT Start value for the SG
4 INCREMENT LARGEINT Increment for the SG
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 LARGEINT The maximum value for
the SG
8 MIN_VALUE LARGEINT The minimum value for
the SG
9 CYCLE_OPTION CHAR(2) Y/N indication if the
CYCLE option was used
* Indicates primary key
Column number Column Name Data Type Description
*1 SG_OBJECT_UID LARGEINT Object UID of used SG
object
*2 USING_OBJECT_OB
J_UID
LARGEINT Object UID of using object
*3 SG_CAT_UID LARGEINT Catalog UID of used SG
object
*4 USING_OBJECT_CA
T_UID
LARGEINT Catalog UID of using
object