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  %Bitshift Functions3
1  %CARDINALITY Function4
1  %SQLCODE Function5
1  %DBINFO Function6
1   %Encryption and Decryption Functions7
1  %Exponential and Logarithmic Functions8
1  %HEX Function9
1  %Length Functions10
1  %OLAP Window Functions11
1   %Security Label Support Functions12
1   %Smart-Large-Object Functions13
1  %Time Functions14
1  %Trigonometric Functions15
1  %String-Manipulation Functions16
1  %IFX_ALLOW_NEWLINE Function17
1  %User-Defined Functions18
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)