JDBC Driver for SQL/MX Programmer's Reference

DEGREES DEGREES
EXP EXP
FLOOR FLOOR
LOG LOG
LOG10 LOG10
MOD MOD
PI PI
POWER POWER
RADIANS RADIANS
RAND
Not supported in this release
ROUND
Not supported in this release
SIGN SIGN
SIN SIN
SQRT SQRT
TAN TAN
TRUNCATE
Not supported in this release
String Functions
JDBC Function SQL/MX Equivalent Function
ASCII ASCII
CHAR CHAR
CONCAT
Supported, but no equivalent
SQL/MX function
DIFFERENCE
Not supported
INSERT INSERT
LCASE LOWER
LEFT SUBSTRING
LENGTH LENGTH
LOCATE LOCATE (JDBC LOCATE start
parameter is not supported)
LTRIM TRIM...LEADING
REPEAT REPEAT
REPLACE REPLACE
RIGHT RIGHT
RTRIM TRIM...TRAILING
SOUNDEX
Not supported
SPACE SPACE
SUBSTRING SUBSTRING