R299 – Multiple nested IF conditions. Use ELSEIF or CASE statement to get quicker dropout (WMB)

Multiple nested IF conditions. Use ELSEIF or CASE statement to get quicker dropout (WMB)

For example   DECLARE I INTEGER;
  DECLARE size CHARACTER;

  IF I = 0 THEN
    SET size = ‘small’;
  ELSE
    IF I = 2 THEN
      SET size = ‘medium’;
    ELSE
      IF I = 3 THEN
        SET size = ‘large’;
      ELSE
        SET size = ‘unknown’;
      END IF;
    END IF;
  END IF;