Evaluate Functions

Evaluate functions are database functions that can be used to pass through expressions to get advanced calculations.

Embedded database functions can require one or more columns. These columns are referenced by %1 ... %N within the function. The actual columns must be listed after the function.

Function	Example	Description
Evaluate	SELECT EVALUATE('instr(%1, %2)', address, 'Foster City') FROM employees	Passes the specified database function with optional referenced columns as parameters to the database for evaluation.
Evaluate_Aggr	EVALUATE_AGGR('REGR_SLOPE(%1, %2)', sales.quantity, market.marketkey)	Passes the specified database function with optional referenced columns as parameters to the database for evaluation. This function is intended for aggregate functions with a GROUP BY clause.