ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-64
PROCEDURE Statements
Example
The following ADD PROCEDURE_COLUMNS statement adds a parameter definition
to the stored procedure named SELECT_DEPT3000, owned by user SQL_DAVE, in
the NonStop ODBC Server catalog \TESS.$DATA1.DB:
ADD PROCEDURE_COLUMNS tess_data1_db.sql_dave.select_dept3000 &
tenure INT NULLABLE INPUT/OUTPUT
MODIFY PROCEDURE
The MODIFY PROCEDURE statement modifies the entry for a stored procedure in the
ZNUPROC table and all entries associated with the procedure in the ZNUPCOL table.
To execute MODIFY PROCEDURE, you must be a privileged user.
logical-procedure-name
specifies the name of the stored procedure you want to modify. For a description of
the MODIFY PROCEDURE parameters, see the ADD PROCEDURE statement.
Considerations – MODIFY PROCEDURE
The MODIFY PROCEDURE statement:
•
Modifies the specified procedure in the ZNUPROC catalog table
•
Modifies all entries associated with the procedure in the ZNUPCOL table
•
Generates an error if you are not authorized to modify the current user catalog
•
If you change the value of a single attribute in MODIFY PROCEDURE, you must
restate every attribute-value pair.
If an error occurs, the effects of MODIFY PROCEDURE are rolled back.
Example
MODIFY PROCEDURE tess_data1_db.sql_dave.select_dept3000 &
PATHMON_NAME $empsp &
SERVICE EMP-DATA-DML &
NUM_RESULT_SETS 1 &
MAX_BUFFER_LEN 2000
MODIFY PROCEDURE logical-procedure-name
PATHMON_NAME pathmon-processname
SERVERCLASS server-class-name
[ SERVICE service-name ]
[ NUM_RESULT_SETS result-set-count ]
[ RETURN_STATUS { Y | N } ]
[ MAX_BUFFER_LEN ipc-message-buffer-len ]
[ REMARKS "remarks-text" ]