MX Release 3.1 (H06.23+, J06.12+)

Contents

HP NonStop Open System Services ODBC/MX Client Driver for SQL/MX Release 3.1—663857-001

iii

Glossary

Index

Examples

Example A-1. Example for compiling a threaded program A-1

Example A-2. Example for linking a threaded program A-1

Example A-3. Sample ODBC Application Code A-3

Figures

Figure 1-1. OSS ODBC/MX Client Driver Architecture on NonStop 1-3

Figure 1-2. Connection Data Flow 1-5

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