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

SQL/MX Statements

HP NonStop SQL/MX Reference Manual—540440-003

2-33

CONTROL QUERY DEFAULT Statement

The CONTROL QUERY DEFAULT statement changes the system-level default

settings for the current process. Execution of this statement does not change the

contents of the SYSTEM_DEFAULTS table. See System Defaults Table on

page 10-30.

CONTROL QUERY DEFAULT is an SQL/MX extension.

attribute

is a character string that represents an SQL/MX attribute name and corresponds to

the ATTRIBUTE column of the SYSTEM_DEFAULTS table. For descriptions of

these attributes, see Default Attributes on page 10-32.

attr-value

is a character string that specifies an SQL/MX attribute value and corresponds to

the ATTR_VALUE column of the SYSTEM_DEFAULTS table. You must specify it

as a quoted string—even if the value is a number.

RESET

specifies that the attribute that you set by using a CONTROL QUERY DEFAULT

statement in the current session is to be reset to the value or values in effect at the

start of the current session.

specifies all attributes are to be reset.

Considerations for CONTROL QUERY DEFAULT

Scope of CONTROL QUERY DEFAULT

The result of the execution of a CONTROL QUERY DEFAULT statement stays in effect

until the current process terminates or until the execution of another statement for the

same attribute overrides it. For a detailed list of the precedence of default settings,

see System Defaults Table on page 10-30.

CONTROL QUERY DEFAULT control-default-option

control-default-option is:

attribute {'attr-value' | RESET}

| * RESET