ODBC Server Reference Manual

Stored Procedures
HP NonStop ODBC Server Reference Manual—429151-002
5-54
Installation of Stored Procedures
Returns: if successful -- SPELIB_OK
else -- an SPELIB error
___________________________________________________________________*/
short int TRACEON( void *env
, unsigned long int max_len
, char *output_buffer
, short int *reply_err
);
Installation of Stored Procedures
The following describes the procedures and mechanisms for installing stored
procedures and for removing them when they are no longer needed. Installation and
removal of stored procedures affect the mapping tables ZNUOBJ, ZNUPCOL,
ZNUPCI1, ZNUPROC, and ZVUPCOL. See Section 8, HP NonStop ODBC Server
Mapping Tables, for details on the mapping tables that support stored procedures.
Catalog Utilities
The NonStop ODBC Server provides two catalog utilities, ADD PROCEDURE and
REMOVE PROCEDURE, for installing and removing stored procedures.
For a catalog created with an earlier version of the NonStop ODBC Server, you must
execute a USERCAT UPGRADE statement to upgrade the catalog to the level that
supports stored procedures before you can execute the ADD PROCEDURE or
REMOVE PROCEDURE statements.
All of the catalog utilities are described in detail in Section 7, Managing Customized
Catalogs.