SYSVARIABLES catalog table
The SYSVARIABLES table contains one row for each global variable that is created. The schema is SYSIBM.
Column name | Data type | Description | Use |
---|---|---|---|
VARID | BIGINT
NOT NULL GENERATED ALWAYS AS IDENTITY |
The identifier of the global variable. | G |
SCHEMA | VARCHAR(128)
NOT NULL |
The schema name of the global variable. | G |
NAME | VARCHAR(128)
NOT NULL |
The unqualified name of the global variable. | G |
OWNER | VARCHAR(128)
NOT NULL |
The authorization ID of the owner of the global variable. | G |
OWNERTYPE | CHAR(1)
NOT NULL |
The type of owner of the global variable:
|
G |
RELCREATED | CHAR(1)
NOT NULL |
The release of Db2 that is used to create the object. See Release dependency indicators for all other values. | G |
CREATEDTS | TIMESTAMP
NOT NULL |
Time at which the global variable was created. | G |
TYPESCHEMA | VARCHAR(128)
NOT NULL |
The schema name of the data type. For built-in data types, this value is SYSIBM. | G |
TYPENAME | VARCHAR(128)
NOT NULL |
The unqualified name of the data type. | G |
DATATYPEID | INTEGER
NOT NULL |
For a built-in data type, the internal ID of the built-in type. For a user-defined type, the internal ID of the user-defined type. | S |
SOURCETYPEID | INTEGER
NOT NULL |
For a built-in data type, 0. For a user-defined type, the internal ID of the built-in data type on which the user-defined type is based. | S |
LENGTH | INTEGER
NOT NULL |
The maximum length of the global variable. If the variable is an array type, the value is 0. | G |
SCALE | SMALLINT
NOT NULL |
The scale of the global variable. | G |
CCSID | INTEGER
NOT NULL |
If the variable is an array type, the value is 0. Otherwise, the CCSID of the global variable. | G |
DEFAULT | CHAR(3)
NOT NULL |
The default value of the global variable. This column can contain one of the following values:
If this column contains one of the following values, the default value of the global variable is the value of the indicated special register at the time that a default value is used: |
G |
DEFAULT (continued) |
|
||
ROWID | ROWID
NOT NULL GENERATED ALWAYS |
The ROWID value for the lob columns in this table. | G |
DEFAULTTEXT | CLOB(2M)
NOT NULL WITH DEFAULT |
The text of the default value of the global variable. | G |
— | BLOB(2M)
NOT NULL |
Reserved for future IBM® use. | I |
ENVID | INTEGER
NOT NULL |
Internal environment identifier. | G |
REMARKS | VARCHAR(762)
NOT NULL |
A character string about this global variable that is provided by using the COMMENT statement. | G |
IBMREQD | CHAR(1)
NOT NULL |
A value of Y indicates that the row was provided with the Db2 product code. For all other values, see Release dependency indicators. The value in this field is not a reliable indicator of release dependencies. RELCREATED should be used instead. |
G |