Library /sys$common/syshlp/SQL$HELP_OLD72.HLB — IF Control, Examples
Example 1: Using an IF control statement
IF (SELECT COUNT (*) FROM STUDENTS
WHERE CLASS = :CLASS_NUM)
> 30
THEN
SET :MSG = 'Class is too large.';
ELSE
SET :MSG = 'Class size is O.K.';
END IF;