The SYSSEQUENCES view contains one row for every sequence object in the SQL
schema. The following table describes the columns in the SYSSEQUENCES
view:
Column name | System Column Name | Data Type | Description |
---|---|---|---|
SEQUENCE_SCHEMA | SEQSCHEMA | VARCHAR(128) | The name of the SQL schema containing the sequence. |
SEQUENCE_NAME | SEQNAME | VARCHAR(128) | Name of the sequence. |
MAXIMUM_VALUE | MAXVALUE |
DECIMAL(63,0) | Maximum value of the sequence. |
MINIMUM_VALUE | MINVALUE |
DECIMAL(63,0) | Minimum value of the sequence. |
INCREMENT | INCREMENT |
INTEGER | Increment value of the sequence. |
CYCLE_OPTION | CYCLE |
VARCHAR(3) | Identifies whether the sequence values will continue to be generated after
the minimum or maximum value has been reached.
|
CACHE | CACHE |
INTEGER | Specifies the number of sequence values that may be preallocated for faster access. Zero indicates that the values will not be preallocated. |
ORDER | ORDER |
VARCHAR(3) | Specifies whether the sequence values must be generated in order of the
request.
|
DATA_TYPE | DATA_TYPE | VARCHAR(128) | Type of sequence:
|
NUMERIC_PRECISION | PRECISION |
INTEGER | The precision of all numeric columns. |
USER_DEFINED_TYPE_SCHEMA | TYPESCHEMA |
VARCHAR(128) Nullable | The name of the schema if this is a distinct type.
Contains the null value if the sequence is not a distinct type. |
USER_DEFINED_TYPE_NAME | TYPENAME |
VARCHAR(128) Nullable | The name of the distinct type.
Contains the null value if the sequence is not a distinct type. |
START | START |
DECIMAL(63,0) | Starting value of the sequence. |
MAXASSIGNEDVAL | MAXASNVAL |
DECIMAL(63,0) Nullable | Last possible assigned sequence value. This value includes any
values that were cached, but not used.
Contains the null value when the sequence is created. Is not null after the first value is assigned. |
SEQUENCE_DEFINER | DEFINER | VARCHAR(128) | The authorization ID under which the sequence was created. |
SEQUENCE_CREATED | CREATEDTS | TIMESTAMP | Timestamp when the sequence was created. |
LAST_ALTERED_TIMESTAMP | ALTEREDTS | TIMESTAMP | Timestamp when the sequence was last altered. |
SEQUENCE_TEXT | LABEL |
VARCHAR(50) Nullable | A character string supplied with the LABEL statement (sequence
text).
Contains the null value if the sequence has no sequence text. |
LONG_COMMENT | REMARKS |
VARCHAR(2000) Nullable | A character string supplied with the COMMENT statement.
Contains the null value if there is no long comment. |
SYSTEM_SEQ_SCHEMA | SYSSSCHEMA | CHAR(10) | The system name of the schema |
SYSTEM_SEQ_NAME | SYSSNAME | CHAR(10) | The system name of the sequence |
IASP_NUMBER | IASPNUMBER | SMALLINT | Specifies the independent auxiliary storage pool (IASP) number. |
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.