JDBC Driver for SQL/MX Programmer's Reference

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

CURDATE,

CURRENT_DATE

CURTIME,

CURRENT_TIME

DAY DAY

EXTRACT EXTRACT

DAYNAME

Not supported

DAYOFMONTH

Not supported

DAYOFWEEK DAYOFWEEK

DAYOFYEAR DAYOFYEAR

HOUR HOUR

MINUTE MINUTE

MONTH MONTH

MONTHNAME MONTHNAME

NOW NOW

QUARTER QUARTER

SECOND SECOND

TIMESTAMPADD

Not supported

TIMESTAMPDIFF

Not supported

WEEK WEEK

System Functions

JDBC Function SQL/MX Equivalent Function

DATABASE

Not supported in this release

IFNULL

Not supported in this release

USER USER

CONVERT Function

JDBC/MX uses the SQL/MX CAST function to support the JDBC CONVERT function. The JDBC CONVERT function has the following

format:

{ fn CONVERT( value_exp, data_type ) }