MX Release 3.2 (H06.25+, J06.14+)

ManualsBrandsHP ManualsServerHP Integrity NonStop H-Series

Contents

HP NonStop ODBC/MX Driver for Windows—691126-003

iii

6. ODBC/MX Messages

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

Microsoft Escape Clauses 5-14

Stored Procedures 5-14

Transactions and Cursor Behavior with Multiple Statements 5-15

Timestamp Values with Fraction 5-15

6. ODBC/MX Messages

ODBC/MX Driver Error Codes 6-1

ODBC/MX Client Messages 6-1

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-13

Table 5-18.

Microsoft Escape Clauses 5-14

Table 5-19.

Transactions and Cursor Behavior 5-15

Table 5-20.

Sample Values Inserted From a C/C++ Program and Their

Corresponding Expected Values in Microsecond 5-16

Table 5-21.

Sample Values Inserted From a C/C++ Program and Their

Corresponding Expected Values in Nanosecond 5-17

Table 5-22. SYSTEM_DEFAULT Values Retrieved Using a C/C++ Program 5-18