MX Release 3.2.1 (H06.26+, J06.15+)

Table 14 String Functions (continued)

SQL/MX Equivalent FunctionODBC Function

Not supportedDIFFERENCE

INSERTINSERT

LOWERLCASE

SUBSTRINGLEFT

Supported, but no equivalent SQL/MX function.LENGTH

LOCATE (ODBC LOCATE start parameter is not supported.)LOCATE

TRIM...LEADINGLTRIM

REPEATREPEAT

REPLACEREPLACE

RIGHTRIGHT

TRIM...TRAILINGRTRIM

Not supportedSOUNDEX

SPACESPACE

SUBSTRINGSUBSTRING

UPPER | UPSHIFTUCASE

NOTE: ODBC 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. Therefore, the results from some ODBC string functions can include trailing blanks at

the end of the string. Use the RTRIM function in queries to cause SQL/MX to trim the extra blanks

from the column names.

Table 15 Time and Date Functions

SQL/MX Equivalent FunctionODBC Function

CURRENT_DATECURDATE, CURRENT_DATE

CURRENT_TIMECURTIME, CURRENT_TIME

DAYDAY

EXTRACTEXTRACT

Not supportedDAYNAME

Not supportedDAYOFMONTH

DAYOFWEEKDAYOFWEEK

DAYOFYEARDAYOFYEAR

HOURHOUR

MINUTEMINUTE

MONTHMONTH

MONTHNAMEMONTHNAME

Supported, but no equivalent SQL/MX function.NOW

QUARTERQUARTER

SQL Conformance Level 37