|A new catalog view has been added:
|The view SYSCAT.SEQUENCES is automatically generated for databases created |with FixPak 3 or later. For databases created prior to FixPak 3, run the db2updv7 command in order to add the view to the database. |See the Command Reference update in the Release Notes for details.
|This catalog view is updated during normal operation, in response to SQL |data definition statements, environment routines, and certain utilities. Data |in the catalog view is available through normal SQL query facilities. Columns |have consistent names based on the type of objects that they describe. |
|
|Table 30. Columns in SYSCAT.SEQUENCES Catalog View
Column Name | Data Type | Nullable | Description |
---|---|---|---|
SEQSCHEMA | VARCHAR(128) |
| Schema of the sequence. |
SEQNAME | VARCHAR(128) |
| Sequence name (generated by DB2 for an identity column). |
DEFINER | VARCHAR(128) |
| Definer of the sequence. |
OWNER | VARCHAR(128) |
| Owner of the sequence. |
SEQID | INTEGER |
| Internal ID of the sequence. |
SEQTYPE | CHAR(1) |
| Sequence type
|
INCREMENT | DECIMAL(31,0) |
| Increment value. |
START | DECIMAL(31,0) |
| Starting value. |
MAXVALUE | DECIMAL(31,0) | Yes | Maximal value. |
MINVALUE | DECIMAL(31,0) |
| Minimum value. |
CYCLE | CHAR(1) |
| Whether cycling will occur when a boundary
is reached:
|
CACHE | INTEGER |
| Number of sequence values to preallocate in memory for faster access. 0 indicates that values are not preallocated. |
ORDER | CHAR(1) |
| Whether or not the sequence numbers must
be generated in order of request:
|
DATATYPEID | INTEGER |
| For built-in types, the internal ID of the built-in type. For distinct types, the internal ID of the distinct type. |
SOURCETYPEID | INTEGER |
| For a built-in type, this has a value of 0. For a distinct type, this is the internal ID of the built-in type that is the source type for the distinct type. |
CREATE_TIME | TIMESTAMP |
| Time when the sequence was created. |
ALTER_TIME | TIMESTAMP |
| Time when the last ALTER SEQUENCE statement was executed for this sequence. |
PRECISION | SMALLINT |
| The precision defined for a sequence with a decimal or numeric type. Values are: 5 for a SMALLINT, 10 for INTEGER, and 19 for BIGINT. |
ORIGIN | CHAR(1) |
| Sequence Origin
|
REMARKS | VARCHAR(254) | Yes | User supplied comments, or null. |