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-7
SQL Conformance Level
SQL Conformance Level
ODBC/MX conforms to the SQL language entry level of SQL-92. This subsection
describes the ODBC/MX support for:
SQL Scalar Functions on page 5-7
ODBC Data Types on page 5-10
Microsoft Escape Clauses on page 5-14
Stored Procedures on page 5-14
Transactions and Cursor Behavior with Multiple Statements on page 5-15
Timestamp Values with Fraction on page 5-15
SQL Scalar Functions
SQLCloseCursor 3.0 Yes Closes a cursor that has been opened
on a statement handle.
SQLCancel 1.0 Yes Closes a cursor that has been opened
on a statement handle.
Note: See the considerations
underSQLCancel Function
on
page 1-9.
SQLEndTran 3.0 Yes Commits or rolls back a transaction.
Table 5-10. Terminating a Connection
Function
ODBC
Version
Supported by
ODBC/MX Description and Notes
SQLDisconnect 1.0 Yes Closes the connection.
SQLFreeHandle 3.0 Yes Releases an environment, connection,
statement, or descriptor handle.
Table 5-11. Numeric Functions (page 1 of 2)
ODBC Function SQL/MX Equivalent Function
ABS ABS
ACOS ACOS
ASIN ASIN
ATAN ATAN
Table 5-9. Terminating a Statement
Function
ODBC
Version
Supported by
ODBC/MX Description










