SYSCAT.VARIABLES catalog view

Each row represents a global variable.

Table 1. SYSCAT.VARIABLES Catalog View
Column Name Data Type Nullable Description
VARSCHEMA VARCHAR (128)   Schema name of the global variable if VARMODULEID is null; otherwise schema name of the module to which the global variable belongs.
VARMODULENAME VARCHAR (128) Y Unqualified name of the module to which the global variable belongs. The null value if not a module variable.
VARNAME VARCHAR (128)   Unqualified name of the global variable.
VARMODULEID INTEGER Y Identifier for the module to which the global variable belongs. The null value if not a module variable.
VARID INTEGER   Identifier for the global variable.
OWNER VARCHAR (128)   Authorization ID of the owner of the global variable.
OWNERTYPE CHAR (1)  
  • U = The owner is an individual user
CREATE_TIME TIMESTAMP   Time at which the global variable was created.
LAST_REGEN_TIME TIMESTAMP   Time at which the default expression was last regenerated.
VALID CHAR (1)  
  • N = The global variable is invalid
  • Y = The global variable is valid
PUBLISHED CHAR (1)   Indicates whether the module variable can be referenced outside its module.
  • N = The module variable is not published
  • Y = The module variable is published
  • Blank = Not applicable
TYPESCHEMA VARCHAR (128)   Schema name of the data type if TYPEMODULEID is null; otherwise schema name of the module to which the data type belongs.
TYPEMODULENAME VARCHAR (128)   Unqualified name of the module to which the variable data type belongs. The null value if the variable data type does not belong to a module.
TYPENAME VARCHAR (128)   Unqualified name of the data type.
TYPEMODULEID INTEGER Y Identifier for the module to which the variable data type belongs. The null value if the variable data type does not belong to a module.
LENGTH INTEGER   Maximum length of the global variable.
SCALE SMALLINT   Scale if the global variable data type is DECIMAL or distinct type based on DECIMAL; the number of digits of fractional seconds if the global variable data type is TIMESTAMP or distinct type based on TIMESTAMP; 0 otherwise.
TYPESTRINGUNITS VARCHAR (11) Y In a Unicode database, the string units that apply to a character string or graphic string data type. Otherwise, the null value.
STRINGUNITSLENGTH INTEGER Y In a Unicode database, the declared number of string units for a character string or graphic string data type. Otherwise, the null value.
CODEPAGE SMALLINT   Code page of the global variable.
COLLATIONSCHEMA VARCHAR (128)   Schema name of the collation for the variable.
COLLATIONNAME VARCHAR (128)   Unqualified name of the collation for the variable.
COLLATIONSCHEMA_ORDERBY VARCHAR (128)   Schema name of the collation for ORDER BY clauses in the variable.
COLLATIONNAME_ORDERBY VARCHAR (128)   Unqualified name of the collation for ORDER BY clauses in the variable.
SCOPE CHAR (1)   Scope of the global variable.
  • D = Database
  • S = Session
DEFAULT CLOB (64K) Y Expression used to calculate the initial value of the global variable when first referenced.
QUALIFIER VARCHAR (128) Y Value of the default schema at the time the variable was defined.
FUNC_PATH CLOB (2K) Y SQL path in effect when the variable was defined.
NULLS CHAR (1)   Reserved for future use.
READONLY CHAR (1)  
  • C = Read-only because the global variable is defined with a CONSTANT clause
  • N = Not read-only
  • S = Read-only because the global variable value is maintained by the database manager
ENVSTRINGUNITS VARCHAR (11)   Default string units when the object was created.
REMARKS VARCHAR (254) Y User-provided comments, or the null value.