Skip to main content

1E 8.1 (on-premises)

EVALUATE

Keywords

EVALUATE

Purpose

Immediately terminate an instruction with exit code "Success, no content" if the preceding statement returned no results.

Description

Syntax

//SQL statements
EVALUATE;

EVALUATEcauses an instruction to terminate with exit code of 1 meaning “Success, no content” if the preceding statement returned no results.

EVALUATE is the simplest form of flow control, and allows you to optimize your instruction and improve its readability, by avoiding unnecessary execution of subsequent statements.

Examples

See SCALE User Guide: Using "EVALUATE" to break on no output.

Notes