SQL Reference Guide

Scalar Functions

FairCom DB SQL does not provide a mechanism for calling a scalar function directly from a user-defined function. To use scalar functions, it is necessary to call the function from within a FairCom DB SQL statement. FairCom DB SQL defines the special table SYSCALCTABLE which has only one row for use in situations where all the data is in the inputs.

In This Section ABS function (ODBC compatible) ACOS function (ODBC compatible) ADD_MONTHS function (extension) ASCII function (ODBC compatible) ASIN function (ODBC compatible) ATAN function (ODBC compatible) ATAN2 function (ODBC compatible) CASE (SQL-92 Compatible) CAST function (SQL-92 compatible) CEILING function (ODBC compatible) CHAR function (ODBC compatible) CHARTOROWID (extension) CHR function (extension) COALESCE (SQL-92 compatible) CONCAT function (ODBC compatible) CONVERT function (extension) CONVERT function (ODBC compatible) COS function (ODBC compatible) COT SQL Scalar Function CURDATE function (ODBC compatible) CURRENT_DATE SQL function CURRENT_TIMESTAMP function CURRENT_USER SQL Function CURTIME function (ODBC compatible) DATABASE (ODBC compatible) DATALENGTH function DATEADD function DATEDIFF function DAYNAME function (ODBC compatible) DAYOFMONTH function (ODBC compatible) DAYOFWEEK function (ODBC compatible) DAYOFYEAR function (ODBC compatible) DB_NAME (extension) DECODE function (extension) DEGREES function (ODBC compatible) DIFFERENCE function (ODBC compatible) EXP function (ODBC compatible) EXTRACT SQL Function FLOOR function (ODBC compatible) GETDATE function (ODBC compatible) GREATEST function (extension) HOUR function (ODBC compatible) IFNULL function (ODBC compatible) INITCAP function (extension) INSERT function (ODBC compatible) INSTR function (extension) ISNULL function ISNUMERIC function LAST_DAY function (extension) LAST_IDENT function (extension) LAST_ROWID function LCASE function (ODBC compatible) LEAST function (extension) LEFT function (ODBC compatible) LEN function (ODBC compatible) LENGTH function (ODBC compatible) LOCATE function (ODBC compatible) LOCALTIME SQL Function LOCALTIMESTAMP SQL Function LOG SQL Scalar Function LOG10 function (ODBC compatible) LOWER function (SQL-92 compatible) LPAD function (extension) LTRIM function (ODBC compatible) MINUTE function (ODBC compatible) MOD function (ODBC compatible) MONTHNAME function (ODBC compatible) MONTH function (ODBC compatible) MONTHS_BETWEEN function (extension) NEXT_DAY function (extension) NOW function (ODBC compatible) NULLIF (SQL-92 compatible) NVL function (extension) OBJECT_ID function (extension) OCTET_LENGTH SQL Function OVERLAY SQL Function PI function (ODBC compatible) POSITION SQL Function POWER function (ODBC compatible) PREFIX function (extension) QUARTER function (ODBC compatible) RADIANS function (ODBC compatible) RAND function (ODBC compatible) REPEAT function (ODBC compatible) REPLACE function (ODBC compatible) RIGHT function (ODBC compatible) ROUND function ROWID (extension) ROWIDTOCHAR (extension) RPAD function (extension) RTRIM function (ODBC compatible) SECOND function (ODBC compatible) SESSION_USER SQL Function SIGN function (ODBC compatible) SIN function (ODBC compatible) SOUNDEX function (ODBC compatible) SPACE function (ODBC compatible) SQRT function (ODBC compatible) SUBSTR function (extension) SUBSTRING SQL Function (SQL-99 compatible) SUBSTRING function (ODBC compatible) SUFFIX function (extension) SUSER_NAME function (extension) SYSDATE function (extension) SYSTIME function (extension) SYSTIMESTAMP function (extension) TAN function (ODBC compatible) TIMESTAMPADD function (ODBC compatible) TIMESTAMPDIFF function (ODBC compatible) TO_CHAR function (extension) TO_DATE function (extension) TO_NUMBER function (extension) TO_TIME function (extension) TO_TIMESTAMP function (extension) TRANSLATE function (extension) TRIM SQL Function TRUNCATE function UCASE function (ODBC compatible) UPPER function (SQL-92 compatible) USER function (ODBC compatible) USER_NAME function (extension) WEEK function (ODBC compatible) YEAR function (ODBC compatible)