ODBC Server Reference Manual

Stored Procedures
HP NonStop ODBC Server Reference Manual—429151-002
5-9
Using the Sample Server
Using the Sample Server
To assist in the development of stored procedures, the following files for a sample
stored procedure server are included with the NonStop ODBC Server product. A set of
three sample stored procedures that have been implemented using the sample server
are also provided.
.
.
.
.
.
12. If any error/warning occurs:
encode_sql_diagnostic [shell routines]
or
SP_SRV_ENCODE_SQL_DIAGNOSTIC [SPELIB]
.
.
.
.
.
.
13. End every SQL statement with:
encode_end_statement [shell routines]
or
SP_SRV_ENCODE_END_STATEMENT [SPELIB]
.
.
.
.
.
.
14. End procedure.
encode_end_proc [shell routines]
or
SP_SRV_ENCODE_END_PROC [SPELIB]
.
.
.
/* PATHSEND terminates. */
15. Reply.
send_reply [shell routines]
.
.free (senv);
ADDSP An OBEY file that contains sample NOSCOM ADD PROCEDURE
commands for registering all of the sample stored procedures.
Sample commands are included for all of the sample stored
procedures.
BINDFILE A sample file for binding the sample server and performing the SQL
compilation step.
CODECOB The working storage declarations referenced from the sample
COBOL85 stored procedure for handling NonStop SQL/MP errors.
CODECOB is distributed as part of the NonStop SQL/MP sample
database.
CSAMPLEC The main routine for the C-only version of the sample server.
CSAMPLE The executable program for running the C-only sample server. This
program includes the stored procedures SELECT_DEPT3000,
SELECT_INPUT_DEPT, and UPDATE_SALARY.
CSHELLC The $RECEIVE handling and SPELIB shell routines used by the C-
only sample server program. Its object file, CSHELLO, is bound in
CSAMPLE.
CSHELLO The object file for CSHELLC.
NonStop ODBC Server Pathway Server