ODBC Server Reference Manual

Stored Procedures
HP NonStop ODBC Server Reference Manual—429151-002
5-11
Using the Sample Server
The Sample Pathway Server Program
The following describes the logic processes of the sample Pathway server program. In
this example, the following assumptions are made:
•
The stored procedure name is SELECT_INPUT_DEPT.
•
The Pathmon process name is $EMPSP.
•
The Pathway server class name is EMP-DATA-DML.
Flow of the Sample Program
Figure 5-3 illustrates the control flow and sequence of events in the sample program.
SP23COB The COBOL85 source code for the sample stored procedure
DEPT9000. This stored procedure returns employee data for
department 9000.
SP24C The C source code for the sample stored procedure SELECT_EMP.
This procedure returns employee data for the specified employee
number. The employee number is a required input parameter.
SPMACRO A file that contains TACL macros for the sample stored procedure
server.