ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-59
PROCEDURE Statements
To execute ADD PROCEDURE, you must be authorized to modify the current user
catalog.
logical-procedure-name
specifies the name of the new stored procedure in the following format:
[ [database.]schema.]procedure-name[;number ]
[ database.. ]
database
specifies a customized database in the current node. The default is the default
database defined in the current profile. If the current profile does not specify a
default database, the default for database is MASTER, unless a USE
DATABASE statement is in effect.
schema
specifies a logical username in the current ZNSUS table. The default is the
username of the current user.
procedure-name
is an alphanumeric string up to 60 characters in length that specifies the name
of the procedure; procedure-name must begin with an alphabetic character,
followed by alphabetic, numeric, and underscore characters.
number
is an integer in the range 0 through 32767 that is appended to the procedure
name to identify the procedure within a group of procedures with the same
name. The default is 1.
This number applies only to Transact-SQL users. To allow procedure sharing
between Transact-SQL and CORE SQL users, HP recommends omitting it.
For more information about database, schema, and procedure names see Names
on page 4-5.
ADD PROCEDURE logical-procedure-name
PATHMON_NAME pathmon-processname
SERVERCLASS pathway-server-class-name
[ SERVICE service-name ]
[ NUM_RESULT_SETS result-set-count ]
[ RETURN_STATUS { N | Y } ]
[ MAX-BUFFER-LEN ipc-message-buffer-len ]
[ REMARKS "remarks-text" ]