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

HP NonStop ODBC/MX Driver for Windows—691126-002
5-1
5 ODBC/MX Conformance
This section contains tables that describe the ODBC/MX conformance to standard
ODBC API functions and SQL conformance levels.
Table Page
ODBC API Functions:
Connecting to a Data Source
5-2
Obtaining Information About a Driver and Data Source
5-2
Setting and Retrieving Driver Attributes
5-3
Setting and Retrieving Descriptor Fields
5-3
Preparing SQL Requests
5-3
Submitting SQL Requests
5-4
Retrieving Results and Information About Results
5-4
Obtaining Information About a Data Source’s System Tables
5-5
Terminating a Statement
5-6
Terminating a Connection
5-7
SQL Scalar Functions:
Numeric Functions
5-7
String Functions
5-8
Time and Date Functions
5-9
System Functions
5-10
CONVERT Function
5-10
SQL Conformance Level:
ODBC Data Types
5-10
Unsigned Data Types
5-12
Partial Date/Time Values
5-12
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
SQL Interval Insertion Property
5-21
SQL Datetime Retrieval Property
5-23










