exit_step_if - full360/sneaql GitHub Wiki

Command: EXIT_STEP_IF

description:

evaluate an expression... exit the current step if condition is true. transform will continue to run starting with the next step.

parameters:

  • required - expression1
  • required - conditional_operator... = != >= =< > <
  • required - expression2

behavior:

  • expressions can be either a numeric literal, or a variable reference enclosed in braces
  • is not associated with a SQL statement

examples:

 /*-exit_step_if :first_insert = 0 -*/
 
 /*-exit_step_if :first_insert > :last_statement_rows_affected -*/