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

SQL Conformance
JDBC/MX conforms to the SQL language entry level of SQL:1999. This subsection describes the JDBC/MX
support for:
SQL Scalar Functions
CONVERT Function
JDBC Data Types
SQL Escape Clauses
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