JDBC Type 4 Driver 2.0 Programmer's Reference (SQL/MX 2.x)

Appendix B. Scalar Functions

This appendix contains a list of scalar functions that are not supported by Module File Caching (MFC):

ABS CURRENT_USER LOG10 POSITION SPACE

ACOS DATEFORMAT LOWER POWER SQRT

ASCII DAY LPAD QUARTER STDDEV

ASIN DAYNAME LTRIM REPEAT SUBSTRING

ATAN DAYOFMONTH MAX REPLACE SUM

ATAN2 DAYOFWEEK MIN RIGHT TAN

AVG DAYOFYEAR MINUTE RPAD TANH

CEILING DIFF1 MOD RTRIM THIS

CHAR DIFF2 MONTH RUNNINGAVG TRANSLATE

CHAR_LENGTH EXP MONTHNAME RUNNINGCOUNT TRIM

CODE_VALUE EXTRACT MOVINGAVG RUNNINGMAX UCASE

CONCAT FLOOR MOVINGCOUNT RUNNINGMIN UPPER

CONVERTTIMESTAMP HOUR MOVINGMAX RUNNINGSTDDEV UPSHIFT

COS INSERT MOVINGMIN RUNNINGSUM USER

COSH JULIANTIMESTAMP MOVINGSTDDEV RUNNINGVARIANCE VARIANCE

COUNT LASTNOTNULL MOVINGSUM SECOND WEEK

CURRENT LCASE MOVINGVARIANCE SESSION_USER YEAR

CURRENT_DATE LEFT OCTET_LENGTH SIGN

CURRENT_TIME LOCATE OFFSET SIN

CURRENT_TIMESTAMP LOG PI SINH

Prev Up Next

Appendix A. Sample Programs

Accessing CLOB and BLOB Data

Home

Glossary

Part Number 529651-006

Legal Notices