MX 2.x)

Contents

HP NonStop ODBC/MX Driver for Windows—527888-004

iii

5. ODBC/MX Conformance (continued)

SQL/MP Data Types and ODBC/MX Equivalents 5-12

Microsoft Escape Clauses 5-13

Stored Procedures 5-14

Transactions and Cursor Behavior with Multiple Statements 5-14

6. ODBC/MX Messages

ODBC/MX Driver Error Codes 6-1

ODBC/MX Client Messages 6-1

Glossary

Index

Figures

Figure 1-1. Connection Data Flow 1-3

Tables

Table 1-1. Release Considerations and Restrictions 1-8

Table 5-1. Connecting to a Data Source 5-2

Table 5-2. Obtaining Information About a Driver and Data Source 5-2

Table 5-3. Setting and Retrieving Driver Attributes 5-3

Table 5-4. Setting and Retrieving Descriptor Fields 5-3

Table 5-5. Preparing SQL Requests 5-3

Table 5-6. Submitting SQL Requests 5-4

Table 5-7. Retrieving Results and Information About Results 5-4

Table 5-8. Obtaining Information About a Data Source’s System Tables 5-5

Table 5-9. Terminating a Statement 5-6

Table 5-10. Terminating a Connection 5-7

Table 5-11. Numeric Functions 5-7

Table 5-12. String Functions 5-8

Table 5-13. Time and Date Functions 5-9

Table 5-14. System Functions 5-10

Table 5-15. ODBC Data Types 5-10

Table 5-16. Behavior of Unsigned Data Types 5-12

Table 5-17. SQL/MP to ODBC/MX Date/Time Mappings 5-12

Table 5-18. Microsoft Escape Clauses 5-13

Table 5-19. Transactions and Cursor Behavior 5-14