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

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-30
System Defaults Table
System Defaults Table
SYSTEM_DEFAULTS Table
Overriding System-Defined Default Settings
Default Attributes
Examples of SYSTEM_DEFAULTS Table
SYSTEM_DEFAULTS is a metadata table in the SYSTEM_DEFAULTS_SCHEMA of
catalog NONSTOP_SQLMX_nodename. that you use to store system-level default
settings that override some of the system-defined default settings. NonStop SQL/MX
uses system-defined default settings for attributes that are associated with compiling
and executing queries. The system-defined default settings, which are hard-coded
settings, are optimal under most circumstances. However, in some circumstances, you
might want to override specific system-defined default settings.
To update the SYSTEM_DEFAULTS table, you must be the super ID or a user to
whom the super ID has granted UPDATE privileges. All other users have SELECT
privileges on this table.
SYSTEM_DEFAULTS Table
The SYSTEM_DEFAULTS table remains empty until you insert rows that contain
default settings. This table shows the columns of the SYSTEM_DEFAULTS table:
Overriding System-Defined Default Settings
The values that you insert into the SYSTEM_DEFAULTS table override the
system-defined default settings. The default settings in the SYSTEM_DEFAULTS table
are considered to be system-level default settings because they persist for all sessions
that use that SYSTEM_DEFAULTS table.
You can override a system-defined default setting or a default setting in the
SYSTEM_DEFAULTS table for the current process, or session, by issuing a
CONTROL QUERY DEFAULT statement or a CONTROL TABLE statement.
Column Name Data Type Description
*1 SUBSYSTEM VARCHAR(30) Subsystem name, default SQLMX. This
value must be SQLMX because only this
subsystem is supported in NonStop
SQL/MX.
*2 ATTRIBUTE VARCHAR(100) Attribute name.
3 ATTR_VALUE VARCHAR(1000) Attribute value.
4 ATTR_COMMENT VARCHAR(1000) Comment.
* Indicates primary key