SYSVARIABLES catalog table

The SYSVARIABLES table contains one row for each global variable that is created. The schema is SYSIBM.

Table 1. SYSIBM.SYSVARIABLES table column descriptions
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: AES CURRENT APPLICATION ENCODING SCHEME ACT CURRENT CLIENT_ACCTNG APN CURRENT CLIENT_APPLNAME CID CURRENT CLIENT_USERID	G
DEFAULT (continued)		WSN CURRENT CLIENT_WRKSTNNAME DAT CURRENT DATE DBG CURRENT DEBUG MODE DEC CURRENT DECFLOAT ROUNDING MODE DEG CURRENT DEGREE EXP CURRENT EXPLAIN MODE LCT CURRENT LOCALE LC_CTYPE MTT CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION MEM CURRENT MEMBER HNT CURRENT OPTIMIZATION HINT CPP CURRENT PACKAGE PATH CPS CURRENT PACKAGESET PTH CURRENT PATH PRC CURRENT PRECISION RFA CURRENT REFRESH AGE RVS CURRENT ROUTINE VERSION RUL CURRENT RULES SCH CURRENT SCHEMA SVR CURRENT SERVER TIM CURRENT TIME TST CURRENT TIMESTAMP STZ SESSION TIME ZONE U SESSION_USER
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