NonStop Server for Java (NSJ) Programmer's Guide (NSJ 2.1+)

SQL Conformance
JDBC/MX conforms to the SQL language entry level of SQL-92. 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
COT
Not supported in this release
DEGREES DEGREES
EXP EXP
FLOOR FLOOR
LOG LOG
LOG10 LOG10
MOD MOD
PI PI
POWER POWER
RADIANS RADIANS
RAND RAND
ROUND
Not supported in this release
SIGN SIGN
SIN SIN