ODBC/MX Driver for Windows Manual (SQL/MX 2.x)

ODBC/MX Conformance
HP NonStop ODBC/MX Driver for Windows—527888-004
5-8
SQL Scalar Functions
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 (page 1 of 2)
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.
LOCATE
LOCATE (ODBC LOCATE start parameter is not supported.)
LTRIM
TRIM...LEADING
Table 5-11. Numeric Functions (page 2 of 2)
ODBC Function SQL/MX Equivalent Function