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 Conformance
HP NonStop ODBC/MX Driver for Windows—691126-002
5-11
ODBC Data Types
FLOAT(p) FLOAT(p)FLOAT(p)Yes
DOUBLE PRECISION DOUBLE PRECISION DOUBLE
PRECISION
Yes
BIT Not supported Not supported No
TINYINT Not supported Not supported No
TINYINT UNSIGNED Not supported Not supported No
BIGINT LARGEINT LARGEINT Yes
BINARY(n) Not supported Not supported No
VARBINARY(n) Not supported Not supported No
LONG VARBINARY Not supported Not supported No
DATE DATE DATE Yes
TIME(p) TIME TIME Yes
TIMESTAMP TIMESTAMP TIMESTAMP Yes
INTERVAL MONTH(p) INTERVAL MONTH(p)Yes
INTERVAL YEAR(p) INTERVAL YEAR(p)Yes
INTERVAL YEAR(p) TO
MONTH
INTERVAL YEAR(p) TO
MONTH
Yes
INTERVAL DAY(p)INTERVAL DAY(p)Yes
INTERVAL HOUR(p) INTERVAL HOUR(p)Yes
INTERVAL MINUTE(p) INTERVAL MINUTE(p)Yes
INTERVAL SECOND(p) INTERVAL SECOND(p)Yes
INTERVAL DAY(p) TO
HOUR
INTERVAL DAY(p) TO
HOUR
Yes
INTERVAL DAY(p) TO
MINUTE
INTERVAL DAY(p) TO
MINUTE
Yes
INTERVAL DAY(p) TO
SECOND
INTERVAL DAY(p) TO
SECOND
Yes
INTERVAL
HOUR(p) TO MINUTE
INTERVAL
HOUR(p) TO MINUTE
Yes
Table 5-15. ODBC Data Types (page 2 of 3)
ODBC
Data Type
SQL/MX
Data Type
SQL/MP
Data Type
Supported by
ODBC/MX