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-8
SQL Scalar Functions
ATAN2 ATAN2
CEILING CEILING
COS COS
COSH COSH
COT Not supported in this release.
DEGREES DEGREES
EXP EXP
FLOOR FLOOR
LOG LOG
LOG10 LOG10
MOD MOD
PI PI
POWER POWER
RADIANS RADIANS
RAND RAND
ROUND Not supported in this release.
SIGN SIGN
SIN SIN
SINH SINH
SQRT SQRT
TAN TAN
TANH TANH
TRUNCATE Not supported in this release.
Table 5-12. String Functions (page1of2)
ODBC Function SQL/MX Equivalent Function
ASCII
ASCII
CHAR
CHAR
CONCAT
CONCAT
DIFFERENCE
Not supported
INSERT
INSERT
LCASE
LOWER
LEFT
SUBSTRING
LENGTH
Supported, but no equivalent SQL/MX function.
Table 5-11. Numeric Functions (page 2 of 2)
ODBC Function SQL/MX Equivalent Function