The SQL scalar functions are used in conditions (*COND() ) of Adelia SQL instructions for VADELIA, SADELIA and WADELIA programs.
Arguments of these functions are either litteral constants, or array columns, or host variables.
For example:
CURSOR C1 ORDER *COND(YEAR(DATE_ORDER) = 2003 AND -
ORDER_SELLER = 'SMITH') *SORT(DATE_ORDER)
Click below to display the list of SQL scalar functions sorted:
- by alphabetical order
- by topic:
- Scalar Functions on Character Strings
- Scalar Functions on the DATE, TIME and TIMESTAMP Types