ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-49
DEFINE Statements
FOR scs-processname
is an alphabetic string up to 15 characters in length in the following format that
specifies the name of the SCS process to associate with this DEFINE statement:
[\node.]$process-name
All processes dependent on scs-processname are also affected by the new
DEFINE. If you omit scs-processname, the DEFINE statement applies to all
SCS processes and their dependent processes.
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 DEFINE
The ADD DEFINE statement:
•
Generates an error if you are not authorized to modify the system catalog
•
Generates an error if you do not specify DEFINE statement attributes in the correct
order
Example
ADD DEFINE =_SQL_CMP_PARALLEL_ON, CLASS MAP, FILE noname FOR
$scs1
REMOVE DEFINE
The REMOVE DEFINE statement deletes an existing DEFINE entry and its related
attributes from the ZNSDEF table. To execute REMOVE DEFINE, you must be
authorized to modify the system catalog.
define-name
is the name of the DEFINE you want to remove.
FOR scs-processname
specifies the name of the SCS process associated with the DEFINE; it is an
alphabetic string up to 15 characters in length in the following format:
[\node.]$process-name
REMOVE DEFINE define-name
[ FOR scs-processname ]
[ UPDATE_SYSTEM_CONFIG ]