版次注意事項


|38.8 Appendix D. Catalog Views

|A new catalog view has been added:

|38.8.1 SYSCAT.SEQUENCES

|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

S - Regular sequence

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:

Y - cycling will occur

N - cycling will not occur

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:

Y - sequence numbers must be generated in order of request

N - sequence numbers are not required to 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

U - User generated sequence

S - System generated sequence

REMARKS VARCHAR(254) Yes User supplied comments, or null.


[ 頁面頂端 | 前一頁 | 下一頁 | 目錄 | 索引 ]