A scalar function is a function that operates on 0 or more value expressions and returns a single value. This value is derived from the expression or expressions named in the function arguments.
Scalar functions can be user-defined or built-in. User-defined functions are defined using a CREATE FUNCTION statement. Built-in functions are known to the DBMS but are not explicitly defined. All built-in functions are provided as part of CA IDMS SQL. During the installation of CA IDMS, a large number of generally useful user-defined functions is defined into the SYSCA schema. For detailed descriptions of the CA-supplied scalar functions, see CA IDMS Scalar Functions.
|
Copyright © 2014 CA.
All rights reserved.
|
|