An Introduction to Functions › Function Types › Function Fields

Function Fields

A function field is a field whose value is not physically stored in the database, but is derived from other fields or files. Function fields are always associated with only one result parameter, the derived field itself, along with a variable number of input parameters that are used to derive the calculation.

CA 2E also provides a number of ready-made function fields such as summing or counting that you can call from within a function. Once the function field is defined, CA 2E automatically incorporates its associated processing logic when it is used. The function fields are:

• Sum (SUM)
• Maximum (MAX)
• Minimum (MIN)
• Count (CNT)
• Derived (DRV)
• User (USR)

For more information on function fields refer to the chapter Defining Functions.