ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-46
CONTROL Statements
CONTROL Statements
The following statements allow you to control various aspects of query execution using
NonStop SQL/MP CONTROL statements:
•
ADD CONTROL
•
REMOVE CONTROL
ADD CONTROL
The ADD CONTROL statement adds a new NonStop ODBC Server control statement
entity to execute at start up time and re-initialization boundaries. A control statement
entity is linked to a profile; the NonStop ODBC Server executes the statement when a
NOS process is started or when you use a profile with an associated CONTROL
statement.
To execute ADD CONTROL, you must be authorized to modify the system catalog.
control-name
is an alphanumeric string up to 60 characters in length that specifies the name of
the control statement entity; control-name must begin with an alphabetic
character, followed by alphabetic, numeric, and underscore characters. The default
for is NULL.
control-text
is an alphanumeric string up to 3900 characters in length, enclosed in double
quotes ("), that specifies the text of the control statement. This text must follow the
syntax for a NonStop SQL/MP CONTROL statement and is checked for validity
only at run time. For more information about CONTROL statements, see the
NonStop SQL/MP Reference Manual.
UPDATE_SYSTEM_CONFIG
resets the time to update system configuration values to the current time. This
option causes running system components to reread their configuration values on
the next polling cycle.
Considerations – ADD CONTROL
The ADD CONTROL statement:
•
Creates a new entry for the control statement entity in ZNSCON
•
Executes the statement when a NOS process is started or when you use a profile
associated with a CONTROL statement
ADD CONTROL control-name "control-text"
[ UPDATE_SYSTEM_CONFIG ]