ODBC Server Reference Manual

Contents
HP NonStop ODBC Server Reference Manual—429151-002
viii
5. Stored Procedures (continued)
5. Stored Procedures (continued)
Design Considerations 5-6
Server Logic Sequence 5-7
Using the Sample Server 5-9
Developing a Stored Procedure in C 5-13
Developing a Stored Procedure in COBOL 5-20
SPELIB Interface 5-27
Shell Routines Interface 5-46
Installation of Stored Procedures 5-54
Catalog Utilities 5-54
Catalog Access 5-55
Other Considerations 5-56
Server I/O Protocol 5-56
Transaction Management 5-56
Fault-Tolerant Programming 5-57
Security 5-58
Break Handling 5-58
Sharing Procedures 5-58
6. Using Pass-Through Mode
Activities Available in Pass-Through Mode 6-1
Entering NonStop SQL/MP Statements 6-1
Running Catalog Utilities 6-1
Setting Server Options 6-2
Using the Trace Feature 6-2
Using Resource Accounting 6-2
Using Pass-Through Syntax 6-3
Example Server Option Specification 6-4
Example UNLOCK Statement 6-4
Example Catalog Utility Statement 6-4
Specifying Server Options in Pass-Through Mode 6-4
Setting the Access Mode 6-4
Setting the Cursor Default Mode 6-5
Setting the Maximum Number of Rows Returned 6-5
Setting the Isolation Level 6-5
Executing a NonStop SQL/MP Statement 6-6
Transactions and Pass-Through Mode 6-7
Available NonStop SQL/MP Statements 6-8
Updating the Mapping Tables 6-12