ODBC Server Reference Manual

Contents

HP NonStop ODBC Server Reference Manual—429151-002

xiv

Figures

Figure 1-1. Workstation-Based Tools Accessing NonStop SQL/MP Using the

NonStop ODBC Server 1-2

Figure 1-2. ODBC Interface 1-3

Figure 1-3. DB-LIBRARY Interface 1-3

Figure 1-4. Relationships Among Applications, the NonStop ODBC Server, and

NonStop SQL/MP 1-4

Figure 2-1. NonStop ODBC Server Generalized Architecture 2-2

Figure 2-2. Application Program Interface for NonStop SQL/MP on a NonStop

Server 2-3

Figure 2-3. Application Program Interface (API) for SQL Server 2-4

Figure 2-4. NonStop ODBC Server in a Client/Server Environment 2-4

Figure 2-5. The NonStop ODBC Server as a SQL Gateway 2-5

Figure 2-6. Two Types of Clients Supported by the NonStop ODBC Server 2-6

Figure 2-7. Database View for a DBLIB Client 2-7

Figure 2-8. Database View for an ODBC Client 2-8

Figure 2-9. Interpreting an ODBC Datasource 2-8

Figure 2-10. SQL Catalog View for a NonStop SQL/MP User 2-9

Figure 2-11. Database View for a NonStop ODBC Server Client 2-10

Figure 2-12. A Client Connection With the NonStop ODBC Server 2-11

Figure 2-13. Client Activities in Using the NonStop ODBC Server 2-12

Figure 2-14. NonStop ODBC Server Client Connection Process 2-13

Figure 2-15. Major Components of the NonStop ODBC Server on a NonStop

Server 2-14

Figure 2-16. Client Connections Through SCS 2-16

Figure 2-17. Message Flow for a Client Connection 2-17

Figure 2-18. Message Flow for Client SQL Execution 2-18

Figure 2-19.

Relationships Among NonStop ODBC Server Objects 2-21

Figure 2-20.

NonStop ODBC Server Catalogs 2-23

Figure 2-21. Support of TSQL Catalog SYSOBJECTS 2-26

Figure 2-22. Life Cycle of an NonStop ODBC Server Process 2-28

Figure 2-23. Processing an SQL Request 2-28

Figure 2-24. Inside the NonStop ODBC Server 2-29

Figure 2-25. SCS Tasks 2-31

Figure 2-26. Interprocess Communication Between SCS and NonStop ODBC

Server 2-32

Figure 2-27. SCS Management of Server Classes 2-33

Figure 2-28. Initializing a NonStop ODBC Server 2-34

Figure 2-29. Client Initiation of Connection 2-35

Figure 2-30. SCS Determination of Server Class 2-36