Overview

This appendix contains an alphabetical listing of the SQL scalar functions that come with CA IDMS. These scalar functions are either built-in or defined in the SYSCA schema as a user-defined function. It is worth knowing if an SQL scalar function is built-in or user-defined because there is a limit on the number of user-defined functions that can be invoked in a single SQL statement.

Note: For more information, see Syntactic Limits.

The table notations are coded as follows:

B = The function is implemented as a true built-in function.
U = The function is implemented as a user-defined function in the SYSCA schema.