NonStop Server for Java (NSJ) Programmer's Guide (NSJ 2.1+)

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
UCASE UPPER | UPSHIFT
Note: JDBC string functions in queries can return unexpected
results for fixed-length (CHAR) column names because
SQL/MX pads a fixed-length string with blanks up to the length
of the definition, so the results from some JDBC string
functions can include trailing blanks at the end of the string.
Use the RTRIM function in queries to cause SQL/MX to trim
extra blanks from the column names.
Time and Date Functions
JDBC Function SQL/MX Equivalent Function