SQL/MX 2.x Reference Manual (H06.04+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-81
ENVIRONMENTVALUES Table
ENVIRONMENTVALUES Table
ENVIRONMENTVALUES is a metadata table in
NONSTOP_SQL_nodename.MXCS_SCHEMA that sets, controls, and defines
environment data:
NAME2ID Table
NAME2ID is a metadata table in NONSTOP_SQL_nodename.MXCS_SCHEMA that
associates service or data source names to an ID:
Column Name Data Type Description
*1 ENV_ID INT Identifier providing link to a parent
object (data source, user or profile)
*2 VARIABLE_SEQUENCE SMALLINT Sort of environment variable based
on type
*3 VARIABLE_TYPE SMALLINT Type of the environment variable:
0 SET
1 CONTROL
2 DEFINE
4 VARIABLE_VALUE VARCHAR(3900) Value of environment variable
5 LAST_UPDATED TIMESTAMP(6) Julian timestamp of last update to
this description
* Indicates primary key
Column Name Data Type Description
*1 OBJ_ID INT Unique identifier
2 OBJ_TYPE SMALLINT Unique identifier
3 OBJ_NAME VARCHAR(128) SQLl_identifier, logical reference to
object
4 VARIABLE_VALUE VARCHAR(390
0)
Reserved for future use
5 LAST_UPDATED TIMESTAMP(6) Julian timestamp of last update to
this description
* Indicates primary key