JDBC Type 2 Driver Programmer's Reference for SQL/MX Release 3.2.1 (H06.26+, J06.15+)

Table 9 Numeric Functions (continued)
SQL/MX Equivalent FunctionJDBC Function
ATAN2ATAN2
CEILINGCEILING
COSCOS
DEGREESDEGREES
EXPEXP
FLOORFLOOR
LOGLOG
LOG10LOG10
MODMOD
PIPI
POWERPOWER
RADIANSRADIANS
SIGNSIGN
SINSIN
SINHSINH
SQRTSQRT
TANTAN
Table 10 String Functions
SQL/MX Equivalent FunctionJDBC Function
ASCIIASCII
CHARCHAR
CHAR_LENGTHCHAR_LENGTH
CONCATCONCAT
INSERTINSERT
LOWERLCASE
SUBSTRINGLEFT
LENGTHLENGTH
LOCATE (JDBC LOCATE start parameter is not supported)LOCATE
LOWERLOWER
LPADLPAD
LTRIMLTRIM
OCTET_LENGTHOCTET_LENGTH
POSITIONPOSITION
REPEATREPEAT
REPLACEREPLACE
RIGHTRIGHT
SQL Conformance 69