IF-THEN-END IF - Teradata Vantage - Analytics 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;