Built-In Functions and Syntax › Built-In Functions

Built-In Functions

Built-in functions are predefined functions in CA OLQ that allow you to:

• Evaluate expressions according to predefined operations and return results that can be used in command mode processing.
• Perform predefined string, arithmetic, trigonometric, and date/time functions.
• Perform aggregate calculations that are based on the GROUP BY processing of the COMPUTE and SELECT commands. These aggregate calculations include:
  • Sum
  • Average
  • Maximum
  • Minimum
  • Count
  • Product
  • Standard deviation
  • Standard deviation population
  • Variance
  • Variance population