A tabela SYSVARIABLES contém uma linha para cada variável global criada.
O esquema é SYSIBM.
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:
- L
- The owner is a role
- blank
- The owner is an authorization ID
|
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:
| N |
The global variable does not have a default value.
If the variable is an array type, the value is N. |
| S |
The default value is the value of the SQL authorization ID of the process at the time that a default value is used. |
| 1 |
The default value is a string constant. |
| 2 |
The default value is a floating-point constant. |
| 3 |
The default value is a decimal constant. |
| 4 |
The default value is an integer constant. |
| 5 |
The default value is a hexadecimal character string. |
| 6 |
The default value is a UX string. |
| 7 |
The global variable has a graphic data type and has a default value that is a character string constant. |
| 8 |
The global variable has a character data type and has a default value that is a character string constant. |
9 |
The default value is a DECFLOAT constant |
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 |
| 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 came from the basic machine-readable material (MRM) tape.
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 |
