ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-61
PROCEDURE Statements
The Pathway server class program should also use MAX_BUFFER_LEN to
allocate the message buffer for I/O. If the maximum buffer size is different between
the requester (the NonStop ODBC Server) and the Pathway server class program,
the lesser of the two sizes is used.
REMARKS remarks-text
specifies arbitrary comments for this stored procedure; it is a string up to 254
characters in length enclosed in double quotation (") marks.
Considerations – ADD PROCEDURE
The ADD PROCEDURE statement:
•
Adds an entry in the ZNUPROC table for the specified procedure
•
Generates an error if you are not authorized to modify the current user catalog
If an error occurs, the actions of ADD PROCEDURE are rolled back.
Example
The following ADD PROCEDURE statement defines a stored procedure named
SELECT_DEPT3000, owned by user SQL_DAVE, in the NonStop ODBC Server
catalog \TESS.$DATA1.DB. The procedure has the Pathmon process name $EMPSP
and server name EMP-DATA-DML, returns one result set, and has a maximum reply
buffer length of 2000 bytes:
ADD PROCEDURE tess_data1_db.sql_dave.select_dept3000 &
PATHMON_NAME $empsp &
SERVERCLASS EMP-DATA-DML &
NUM_RESULT_SETS 1 &
MAX_BUFFER_LEN 16000
ADD PROCEDURE_COLUMNS
The ADD PROCEDURE_COLUMNS statement adds one entry to the ZNUPCOL table
for each parameter definition of a stored procedure.
logical-procedure-name
specifies the name of the stored procedure. For a description of this parameter,
see the ADD PROCEDURE statement.
parameter-declaration
describes each parameter’s name, data type, and usage as follows:
parameter-name parameter-type [ parameter-designation ]
ADD PROCEDURE_COLUMNS logical-procedure-name
( parameter-declaration [,parameter-declaration ]... )