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;

EVALUATE causes an instruction to terminate with exit code of 1 meaning “Success, no contentif 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
Notes