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 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.