ODBC Server Reference Manual

Stored Procedures
HP NonStop ODBC Server Reference Manual—429151-002
5-3
Installing and Using Stored Procedures
2. The NonStop ODBC server translates the stored procedure invocation to a
Pathway server class request, using mapping tables in the NonStop ODBC Server
catalogs to look up the Pathway server class program, and sends the request to
the Pathway server class.
3. The code in the server class process carries out the stored procedure steps.
4. The server class program returns HP NonStop SQL/MP data (or a diagnostic
message) to the NonStop ODBC server.
5. The NonStop ODBC server converts the NonStop SQL/MP output to ODBC or SQL
Server format and sends the result to the application program.
The overall NonStop ODBC Server architecture, as well as the architecture’s support
for stored procedures, is described in detail in Section 2, Architecture Overview.
Installing and Using Stored Procedures
Figure 5-2 Illustrates the steps involved in developing, installing, and executing stored
procedures, and the location of additional information about those steps.
Figure 5-2. Sequence of Activities in Stored Procedure Usage
Develop and install Pathway
server class program(s) to
implement stored procedures.
ODBC and DBLIB applications issue
statements to execute the stored
procedures. The NonStop
ODBC server issues requests to
the Pathway server class.
Using NOSUTIL, add catalog
entries to the NonStop ODBC
Server catalog to represent
the stored procedures.
Described in “Development of Stored
Procedures” in this section, and in the
NonStopTS/MP Pathsend and Server
Programming Manual
and the NonStop
TS/MP System Management Manual
Described in Section 7, “Managing
Customized Catalogs”
Described in “Execution of Stored
Procedures,” in this section
VST041.vsd