ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-60
PROCEDURE Statements
PATHMON_NAME pathmon-processname
specifies the external Guardian name of the Pathmon process; it is an
alphanumeric string up to 15 characters in length in the following format:
[\node-name.]$pathmon-processname
For example, a pathmon-processname might be $PM or \TESS.$PMN.
node specifies the node where the process is running. If node is omitted, the
process location defaults to the current node.
SERVERCLASS pathway-server-class-name
specifies the name of the server class to which calls are to be sent (for example,
EMP-SERVER). It is an alphanumeric string up to 15 characters, beginning with a
letter and optionally containing hyphens (-). This name must conform to the
Pathway server class naming rules, must be left justified in the buffer, and can
contain trailing blanks.
SERVICE service-name
is used for a Pathway server class program to identify a specific service.
service-name has the same format as the procedure-name part of the
three-part procedure name and defaults to that name if omitted.
ADD PROCEDURE does not enforce the uniqueness of service-name; it is the
Pathway programmer’s responsibility to do so.
NUM_RESULT_SETS result-set-count
specifies how many result sets are to be returned; result-set-count is an
integer in the range 0 through 32,767. The default is zero (0).
A result set is a set of rows returned from a SELECT statement. If the stored
procedure contains SELECT statements, the caller receives a result set for each
SELECT statement. A result set includes the column names followed by zero or
more rows of data.
RETURN_STATUS {Y | N }
specifies whether the stored procedure returns a status value in addition to any
output parameter values and result sets:
MAX-BUFFER-LEN ipc-message-buffer-len
specifies the maximum size of the interprocess communication buffer; it is an
integer in the range 0 through 32000. The default is 32000 bytes.
Y Return a status value.
N Do not return a status value. N is the default.