The BTEQ IF...THEN... command is a conventional condition-testing command. After testing the condition stated in the IF clause, BTEQ resumes command execution as follows:
| If | Then |
|---|---|
| If the condition stated in the IF clause is TRUE | BTEQ executes the command stated in the THEN clause. |
| If the condition stated in the IF clause is FALSE | BTEQ does not execute the command stated in the THEN clause, it executes the next command. |
Testing refers to the outcome of the most recent Teradata SQL request, the one that immediately precedes the IF...THEN... command. Branching is based on the outcome of an earlier request.