MX 3.x)

HP NonStop Open System Services ODBC/MX Client Driver—640328-001

Tables

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

Table 2-1. Format of the ODBCDSN file 2-3

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

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

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

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

Table 3-5. Preparing SQL Requests 3-3

Table 3-6. Submitting SQL Requests 3-4

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

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

Table 3-9. Terminating a Statement 3-6

Table 3-10. Terminating a Connection 3-7

Table 3-11. Numeric Functions 3-7

Table 3-12. String Functions 3-8

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

Table 3-14. System Functions 3-9

Table 3-15. ODBC Data Types 3-10

Table 3-16. Behavior of Unsigned Data Types 3-11

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

Table 3-18. Microsoft Escape Clauses 3-13

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

Table 3-20. Sample Values Inserted From a C/C++ Program and Their

Corresponding Expected Values in Microsecond 3-14

Table 3-21. Sample Values Inserted From a C/C++ Program and Their

Corresponding Expected Values in Nanosecond 3-16

Table 3-22. SYSTEM_DEFAULT Values Retrieved Using a C/C++ Program 3-17

Table 3-23.

Sample Values Retrieved Using a C/C++ Program and Their

Corresponding Expected Values in Nanosecond 3-18