ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-47
CONTROL Statements
•
Generates an error at run time if control-text is not a valid NonStop SQL/MP
CONTROL statement
•
Generates an error if you are not authorized to modify the system catalog
Example
ADD CONTROL late_bind "CONTROL QUERY BIND NAMES AT EXECUTION"
REMOVE CONTROL
The REMOVE CONTROL statement deletes an existing control statement entity in the
ZNSCON table. To execute REMOVE CONTROL, you must be authorized to modify
the system catalog.
control-name
specifies the name of the control statement entity you want to remove form the
ZNSCON table.
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 – REMOVE CONTROL
The REMOVE CONTROL statement generates an error if you are not authorized to
modify the system catalog.
Example
REMOVE CONTROL late_bind UPDATE_SYSTEM_CONFIG
REMOVE CONTROL control-name
[ UPDATE_SYSTEM_CONFIG ]