ODBC Server Reference Manual

Contents
HP NonStop ODBC Server Reference Manual—429151-002
xv
Figures (continued)
Figures (continued)
Figure 2-31. NonStop ODBC Server Processes Connection 2-37
Figure 2-32. Minimum Message Flow to Connect a Client 2-37
Figure 2-33. NonStop SQL/MP Execution in SQLCI and NonStop ODBC
Server 2-41
Figure 3-1. Relationship Among CORE SQL, the NonStop ODBC Server, and
NonStop SQL/MP 3-1
Figure 4-1. Relationships Among Transact-SQL, the NonStop ODBC Server, and
NonStop SQL/MP 4-2
Figure 5-1. Executing Stored Procedures 5-2
Figure 5-2. Sequence of Activities in Stored Procedure Usage 5-3
Figure 5-3. Sample Program Flow 5-12
Figure 5-4. SPELIB Sequence for Server Encoding 5-42
Figure 7-1. A NonStop ODBC Server Mapping Table 7-2
Figure 7-2. Tables With Duplicate Names Registered in One Catalog 7-7
Figure 8-1. A NonStop ODBC Server Mapping Table 8-2
Figure 8-2. Relationships Among NonStop ODBC Server Tables 8-6
Figure E-1. A Typical Three-Tier Configuration E-1
Tables
Table 1-1. NonStop ODBC Server Users 1-5
Table 1-2. Hardware and Software Requirements for the NonStop Server 1-5
Table 1-3. Hardware and Software Requirements for Workstations Using ODBC
With Windows 95, Windows 98,Windows 2000, Windows XP or
Windows NT 1-6
Table 1-4. Hardware and Software Requirements for Workstations Using
DBLIB 1-6
Table 1-5. Hardware and Software Requirements for UNIX Workstations 1-7
Table 1-6.
NonStop ODBC Server Support of ODBC Features 1-8
Table 1-7.
NonStop ODBC Server Support of SQL Server Features 1-10
Table 3-1. How the NonStop ODBC Server Maps CORE SQL Object Names 3-4
Table 3-2. Rules for Object Names 3-5
Table 3-3. Conversion of CORE SQL Data Types to NonStop SQL/MP Data
Types 3-9
Table 3-4. Conversion of NonStop SQL/MP Data Types to CORE SQL Data
Types 3-10
Table 3-5. Supported CORE SQL Functions 3-14
Table 3-6. NonStop ODBC Server Support of CORE SQL Operators 3-26
Table 3-7. NonStop ODBC Server Support of Wild-Card Characters 3-29
Table 3-8. NonStop ODBC Server Support of SQL Statements 3-31