ODBC Server Reference Manual

Stored Procedures
HP NonStop ODBC Server Reference Manual—429151-002
5-55
Catalog Access
ADD PROCEDURE
The ADD PROCEDURE statement adds one entry in the ZNUPROC table for
procedure name mapping, and adds one entry in the ZNUPCOL table for each
parameter definition.
REMOVE PROCEDURE
The REMOVE PROCEDURE statement deletes the entry for a procedure from the
ZNUPROC catalog table, and deletes all entries associated with the procedure from
the ZNUPCOL table.
The syntax of the REMOVE PROCEDURE statement is as follows:
Catalog Access
The following describes how users can gain access to the information in the catalog
tables. The methods used depend on whether the user uses Transact-SQL or CORE
SQL, and whether the API is DB-LIBRARY or ODBC.
•
TSQL/DBLIB Access
The SQL Server catalog SYSOBJECTS is extended to support procedure objects.
Use Transact-SQL to query the catalog for information about stored procedures.
•
TSQL/ODBC Access
The TSQL mode user using ODBC has two ways to obtain catalog information
about stored procedures.
•
Use Transact-SQL to query the SQL Server SYSOBJECTS catalog.
ADD PROCEDURE logical-procedure-name
PAT[HMON-NAME] pathmon-name
SER[VERCLASS] server-class-name
[ SERVICE service-name ]
[ NUM_RESULT_SETS result-set-count ]
[ ( parameter-declaration [, ... ] ) ]
[ { NO_RETURN_STATUS | RETURN_STATUS } ]
[ MAX_BUF[FER_LEN] ipc-message-buffer-len ]
[ REMARKS remarks-text ]
REMOVE PROCEDURE logical-procedure-name