EVALUATE
Keywords | |
---|---|
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 |