IF-THEN-END IF - Advanced SQL Engine - Teradata Database

This form of IF executes the statements within the IF and END IF bounds when conditional_expression evaluates to TRUE.

The following statement is an example of IF-THEN-END IF:

   IF hNoAccts = 1 THEN
     INSERT INTO temp_table VALUES (hNoAccts, 'One Customer');
   END IF;