ODBC Server Reference Manual

Stored Procedures
HP NonStop ODBC Server Reference Manual—429151-002
5-10
Using the Sample Server
DBCREATE An OBEY file for creating the sample database (use this only if the
sample database has not already been created).
DBLOAD An OBEY file for populating the sample database.
DROPSP An OBEY file that contains sample NOSCOM REMOVE
PROCEDURE commands to drop the sample stored procedures.
PATHIN An example of a Pathway configuration file. In addition to the
Pathway server class EMP-DATA-DML for the C-only version of the
sample server (CSAMPLE), it includes the server class
EMP-DATA-MIX for use with the mixed-code sample server
(SAMPLE).
SAMPLEC The source code for the main routine of the mixed-code sample
server.
SAMPLE The executable program for the mixed-code sample server. This
program includes the stored procedures DEPT9000 and
SELECT_EMP. The DEPT9000 stored procedure is written in
COBOL85 and SELECT_EMP is written in C. The sample server
shows how stored procedures written in COBOL85 and C can be
mixed.
SAMPLEO The object file for the main routine of the mixed-code sample server.
SHELLC The source code for the shell routines that can be used for
developing stored procedures written in COBOL85 or C.
SHELLO The object file for the shell routines.
SP20C The C source code for the stored procedure SELECT_DEPT300,
which selects employee data from the EMPLOYEE table for
department 3000 and returns the employee number, first name, last
name, and department number of every employee in department
3000 to the client. This procedure has no input parameters, and
returns one result set.
SP21C The C source code for the stored procedure SELECT_INPUT_DEPT,
which selects employee data from the EMPLOYEE table for a
specific department. The department number is a required input
parameter. The procedure returns one result set that includes the
employee number, first name, last name, and department number of
qualified employees to the client.
SP22C The C source code for the stored procedure UPDATE_SALARY,
which updates a given employee’s salary with a new salary amount.
The employee number and new salary are required input parameters.
The procedure returns the employee number, first name, last name,
department, and new salary amount to the client. SP22C is the
source file that contains this procedure.