IF-THEN-END IF - Teradata Vantage

This form of IF runs 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;