Function Expressions

A function expression can return one or more values from built-in SQL functions or from user-defined functions, as the following diagram shows. 
(1)
Function Expressions

1 1
1  %Algebraic Functions2
1  %CARDINALITY
Function3
1  %SQLCODE Function4
1  %DBINFO
Function5
1   %Encryption and Decryption Functions6
1  %Exponential and Logarithmic Functions7
1  %HEX
Function8
1  %Length Functions9
1  %OLAP Window Functions10
1   %Security Label Support Functions11
1   %Smart-Large-Object Functions12
1  %Time Functions13
1  %Trigonometric
Functions14
1  %String-Manipulation Functions15
1  %IFX_ALLOW_NEWLINE
Function16
1  %User-Defined Functions17
Notes:
The following examples show function expressions: 
EXTEND (call_dtime, YEAR TO SECOND)
HEX (LENGTH(123))
MDY (12, 7, 1900 + cur_yr)
TAN (radians)
DATE (365/2)
ABS (-32)
LENGTH ('abc') + LENGTH (pvar)
EXP (3)
HEX (customer_num)
MOD (10,3)