ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-83
SERVERCLASS Statements
NOS_CREATE_OPTIONS nos-create-options
is an INT(2) number that specifies create options for the NOS process. It can be
one of the following :
NOS_DEBUG_OPTIONS nos-debug-options
is an INT(2) number that specifies debugging options for the NOS process. It can
be one of the following:
NOS_RUN_OPTIONS nos-run-options
specifies run options for the NOS process; nos-run-options is an alphanumeric
string up to 240 characters in length enclosed by double quotes ("). If you specify
more than one option, separate each option with a space. nos-run-options can
have these values:
FREE_RESOURCES=n
specifies that ESP and SORTPROG processes used by an SQL statement are
released when the statement is closed if the cost of the statement is greater
than 10 to the nth power.
AGGREGATE_AS_INT={Y|N}
Y causes the result set of each aggregate function to be converted to an
integer value. The NOS process translates an aggregate function as:
CAST (aggregate_function) AS INTEGER)
6 specifies to inherit DEFINEs from the calling process, but ignore DEFINEs
stored in ZNSDEF
22 specifies to inherit DEFINEs from the calling process, and include at least
one DEFINE from ZNSDEF
23 specifies to inherit DEFINEs from the calling process, include at least one
DEFINE from ZNSDEF
0 specifies not to use debugging features
4 specifies to create a SAVEABEND file when NOS abends
8 specifies to enter DEBUG mode at _MAIN
9 specifies to enter INSPECT mode at _MAIN and create a SAVEABEND file
upon trap
12 specifies to enter DEBUG mode at _MAIN, ignore the program default for
debugging, and create a SAVEABEND file upon trap
13 specifies to enter INSPECT mode at _MAIN, ignore the program default for
debugging, and create a SAVEABEND file upon trap