Using variables with SQL statements
Cycle variables can be used in conjunction with SQL statements. Using Cycle variables allows you to build dynamic SQL statements and to pass data into the commands. After a SQL statement is executed, the Step:
I assign row < ROW_NUMBER > column "< COLUMN_NAME >" to variable "< VARIABLE_NAME >"
allows you to save a value from the SQL result set for later use.