ODBC/MX Driver for Windows Manual for SQL/MX Release 3.2.1 (H06.26+, J06.15+)
Table Of Contents
- HP NonStop ODBC/MX Driver for Windows
- Legal Notices
- Contents
- What’s New in This Manual
- About This Manual
- 1 ODBC/MX Client Overview
- 2 Installation of the ODBC/MX Client
- 3 Configuring Client Data Sources on Windows
- Accessing the Microsoft ODBC Data Source Administrator from a Client Workstation
- Adding New Client Data Sources
- Reconfiguring Client Data Sources
- Configuring Client Data Sources using Connection String
- Configuring Client Data Sources for Update Operations
- Configuring Driver for IPV6
- Removing Client Data Sources
- Tracing Client Data Sources
- 4 Module File Caching (MFC)
- 5 ODBC/MX Conformance
- ODBC API Functions
- SQL Conformance Level
- SQL Scalar Functions
- ODBC Data Types
- Unsigned Data Types
- Partial Date/Time Values
- SQL/MP Data Types and ODBC/MX Equivalents
- Microsoft Escape Clauses
- Stored Procedures
- Transactions and Cursor Behavior with Multiple Statements
- Timestamp Values with Fraction
- SQL Interval Insertion Property
- SQL Datetime Retrieval Property
- 6 ODBC/MX Messages
- Glossary
- Index

Contents
HP NonStop ODBC/MX Driver for Windows—691126-002
iii
6. ODBC/MX Messages
SQL/MP Data Types and ODBC/MX Equivalents 5-13
Microsoft Escape Clauses 5-13
Stored Procedures 5-14
Transactions and Cursor Behavior with Multiple Statements 5-15
Timestamp Values with Fraction 5-15
SQL Interval Value Insertion Property 5-21
Datetime Retrieval Property 5-24
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
Figure 3-1. ODBC/MX Data Source Configuration 3-5
Figure 5-1. Data source configuration screen for SQL Interval Value Insertion 5-22
Figure 5-2. Data source configuration screen for SQL Datetime Retrieval 5-24
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










