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
ODBC/MX Client Overview
HP NonStop ODBC/MX Driver for Windows—691126-002
1-11
Unsupported ODBC API Functions and Data Types
Unsupported ODBC API Functions and Data
Types
API Functions
This release of ODBC/MX does not support the following ODBC 3.51 API functions.
For descriptions of the ODBC API functions, see ODBC API Functions on page 5-2.
SQLBulkOperations
SQLFetchScroll - supported for SQL_FETCH_NEXT attribute only
SQLSetScrollOption
Data Types
This release of MXCS does not support the following ODBC data types. For more
information about data types, see ODBC Data Types on page 5-10.
BIT
TINYINT and TINYINT UNSIGNED
BINARY
VARBINARY
LONG VARBINARY
Restricted ODBC API Functions
SQLBindParameter
The SQLBindParameter function has these restrictions:
SQL_DEFAULT_PARAM is not supported for the pcbValue argument.
The SQL_LEN_DATA_AT_EXEC(length) macro is not supported for the pcbValue
argument.
SQLPutData
The SQLPutData function can send data in parts only for the SQL_LONGVARCHAR
data type. For all other data types, only the latest value in the rgbValue argument is
used.
ODBC/MX Driver Features
The ODBC/MX Driver 3.x supports the following features:
Row size limit is increased to align with maximum block size 32768 for MX tables.
A clustering key length up to 2048 bytes is allowed for range and hash partitioned
MX tables.