Open System Services ODBC/MX Client Driver (SQL/MX 3.x)

ODBC/MX Conformance
HP NonStop Open System Services ODBC/MX Client Driver—640328-001
3-8
SQL Scalar Functions
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 3-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
REPEAT
REPEAT
REPLACE
REPLACE
RIGHT
RIGHT
RTRIM
TRIM...TRAILING
SOUNDEX
Not supported
SPACE
SPACE
Table 3-11. Numeric Functions (page 2 of 2)
ODBC Function SQL/MX Equivalent Function