Open System Services ODBC/MX Client Driver Manual for SQL/MX Release 3.2.1 (H06.26+, J06.15+)

• “SQL Interval Behaviour property” (page 46)
• “SQL Datetime Retrieval property” (page 48)
SQL Scalar Functions
Table 13 Numeric Functions
SQL/MX Equivalent FunctionODBC Function
ABSABS
ACOSACOS
ASINASIN
ATANATAN
ATAN2ATAN2
CEILINGCEILING
COSCOS
COSHCOSH
Not supported in this release.COT
DEGREESDEGREES
EXPEXP
FLOORFLOOR
LOGLOG
LOG10LOG10
MODMOD
PIPI
POWERPOWER
RADIANSRADIANS
RANDRAND
Not supported in this releaseROUND
SIGNSIGN
SINSIN
SINHSINH
SQRTSQRT
TANTAN
TANHTANH
Not supported in this release.TRUNCATE
Table 14 String Functions
SQL/MX Equivalent FunctionODBC Function
ASCIIASCII
CHARCHAR
CONCATCONCAT
36 ODBC/MX Conformance