AV | If-Then-Else Example

SQL Language Guide > SQL Statements > IF - THEN - ELSE > If-Then-Else Example

Was this helpful?

If-Then-Else Example

The following IF statement performs a delete or an insert and checks to make sure the statement succeeded:

IF (id > 0) AND (id <= maxid) THEN
       DELETE FROM emp WHERE id = :id;
       IF iierrornumber > 0 THEN
              message 'Error deleting specified row';
              return 1;
       ELSEIF iirowcount = 0 THEN
              message 'Specified row does not exist';
              return 2;
       ENDIF;
ELSEIF (id < maxid) THEN
       INSERT INTO emp VALUES (:name, :id, :status);
       IF iierrornumber > 0 THEN
              message 'Error inserting specified row';
              return 3;
       ENDIF;
ELSE
message 'Invalid row specification';
return 4;
ENDIF;

Last modified date: 01/04/2024