ACTION

An action that is a parameterizable block of multiple top-level expressions.

DEFINE ACTION defines an action that can then be accessed repeatedly using DO.

You can use DO ACTION in the body of the EVALUATE IF condition or EVALUATE FOR cycle.

DEFINE ACTION

Defines an ACTION consisting of the specified expressions.

Syntax

1. DEFINE ACTION: action definition.
2. A named expression that will be used to access the defined action further in the query.
3. The round brackets contain a list of named expressions you can use to access parameters inside the action.
4. AS keyword.
5. List of top-level expressions.
6. END DEFINE: The marker of the last expression inside the action.

DO

Executes an ACTION with the specified parameters.

Syntax

1. DO: Executing an action.
2. The named expression for which the action is defined.
3. The values to be used as parameters are listed in parentheses.

EMPTY_ACTION: An action that does nothing.

Example

DEFINE ACTION $hello_world($name) AS
    $name = $name ?? "world";
    SELECT "Hello, " || $name || "!";
END DEFINE;

DO EMPTY_ACTION();
DO $hello_world(NULL);
DO $hello_world("John");