JDBC Type 2 Driver 3.0 Programmer's Reference (SQL/MX 3.x)

JDBC

Function

SQL/MX Equivalent Function

ASCII ASCII

CHAR CHAR

CHAR_LENGTH CHAR_LENGTH

CONCAT CONCAT

INSERT INSERT

LCASE LOWER

LEFT SUBSTRING

LENGTH LENGTH

LOCATE

(JDBC LOCATE start parameter is not

supported)

LOWER LOWER

LPAD LPAD

LTRIM LTRIM

OCTET_LENGTH OCTET_LENGTH

POSITION POSITION

REPEAT REPEAT

REPLACE REPLACE

RIGHT RIGHT

RTRIM TRIM...TRAILING

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

CONVERTTIMESTAMP CONVERTTMESTAMP

CURRENT CURRENT

CURRENT_TIMESTAMP CURRENT_TIMESTAMP

CURDATE

, CURRENT_DATE

CURRENT_DATE