ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-48
DEFINE Statements
DEFINE Statements
The following statements allow you to use DEFINEs with the SQL Communications
Subsystem (SCS):
•
ADD DEFINE
•
REMOVE DEFINE
A DEFINE is a named set of attribute-value pairs associated with a process. You can
use DEFINEs to pass information to a process when you start the process. For the
NonStop ODBC Server, the DEFINE is linked to an SCS configuration entity and is
propagated when the SCS starts a new process.
For more information about DEFINE classes, attributes, and values, see “DEFINEs”
and “System DEFINEs” in the NonStop SQL/MP Reference Manual.
ADD DEFINE
The ADD DEFINE statement creates a new DEFINE entry in the ZNSDEF system
table. The DEFINE takes effect when SCS starts a new process. To execute ADD
DEFINE, you must be authorized to modify the system catalog.
define-name
is the name of the new DEFINE; define-name is an alphabetic string from 2 to 24
characters in length. The first character must be an equal sign (=), and the second
character must be a letter. The remaining name can be alphanumeric characters,
hyphens (-), and underscores (_).
CLASS define-class
is an alphabetic string up to 16 characters in length that identifies the class of the
new DEFINE. The default is MAP.
define-attribute
is an alphanumeric string up to 512 characters in length that identifies the DEFINE
attribute.
define-value
is the value you assign to define-attribute. To omit define-value, enter
two double quotes (""). For a list of DEFINE attributes and values, see the SET
DEFINE command in the TACL Reference Manual.
ADD DEFINE define-name, [ CLASS define-class, ]
define-attribute [attribute-value ]
[, define-attribute [attribute-value ]...]
[ FOR scs-processname ]
[ UPDATE_SYSTEM_CONFIG ]