test

Command: TEST

description:

compare single value from SQL statement to an expression... exit script if condition evaluates to false.

parameters:

• required - conditional_operator... = != >= =< > <
• required - expression

behavior:

• single value returned from result set will be compared to expression
• expression can be either a numeric literal, or a variable reference enclosed in braces

examples:

 /*-test < 0-*/
 select max(batch_id) from staging.ingestion_control;
 
 /*-test < :some_other_batch_id-*/
 select max(batch_id) from staging.ingestion_control;