IF... THEN... Command Process - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-06-28
dita:mapPath
wmy1488824663431.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.