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.
Function Expressions
Notes:
- 1 HCL OneDB™ extension
- 2 See Algebraic Functions
- 3 See CARDINALITY Function
- 4 See SQLCODE Function (SPL)
- 5 See DBINFO Function
- 6 See Encryption and decryption functions
- 7 See Exponential and Logarithmic Functions
- 8 See HEX Function
- 9 See Length functions
- 10 See OLAP window expressions
- 11 See Security Label Support Functions
- 12 See Smart-Large-Object Functions
- 13 See Time Functions
- 14 See Trigonometric Functions
- 15 See String-Manipulation Functions
- 16 See IFX_ALLOW_NEWLINE Function
- 17 See User-Defined Functions
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)