MX 2.x)

SQL Scalar Functions

JDBC/MX maps JDBC scalar functions to their equivalent SQL/MX functions, as shown in the following tables:

Numeric Functions

JDBC Function SQL/MX Equivalent Function

ABS ABS

ACOS ACOS

ASIN ASIN

ATAN ATAN

ATAN2 ATAN2

CEILING CEILING

COS COS

DEGREES DEGREES

EXP EXP

FLOOR FLOOR

LOG LOG

LOG10 LOG10

MOD MOD

PI PI

POWER POWER

RADIANS RADIANS

SIGN SIGN

SIN SIN

SINH SINH

SQRT SQRT

TAN TAN

String Functions

JDBC Function SQL/MX Equivalent Function

ASCII ASCII

CHAR CHAR

CHAR_LENGTH CHAR_LENGTH

CONCAT CONCAT

INSERT INSERT

LCASE LOWER