ODBC Server Reference Manual

Stored Procedures
HP NonStop ODBC Server Reference Manual—429151-002
5-12
Using the Sample Server
Figure 5-3. Sample Program Flow
select_input_dept
(SP21C)
process_event_queue ( CSHELLC )
• read in $RECEIVE
• process system
message
- set up counter to track how many
OPENs
- decrement count when receive
CLOSE
message
• activate transaction
inherit TMF Trans-ID
• call process_request
main ( CSAMPLE C)
• call spe_register for each stored proc
• call process_event_queue
process_request ( CSHELLC )
• call SPELIB to decode IPC message
• call process_service
process_event_queue (CSHELLC)
send reply back to NonStop ODBC
Loop back until no
more
messages
received
NonStop ODBC
Server
EMP-DATA-DML
Pathmon
$EMPSP
NonStop ODBC
Server
process_service ( CSHELLC )
• call individual stored procedure to
perform work. For example, call
select_input_dept
to select employee info for a dept
• encode selected row and column
headings. For example, call
encode_row_data
to move data to buffer; if it detects
buffer overflow, then call-back
automatically writes IPC buffer back
to NonStop ODBC server
VST042.vsd