Adding columns conditionally using SQL via a stored procedure

CREATE PROCEDURE ROB.NEWFIELD
 LANGUAGE SQL
 BEGIN

DECLARE SQLSTMT CHAR (200) DEFAULT
 'ALTER TABLE ROB.AAAKEY ADD DUH CHAR (10)';

IF NOT EXISTS (
   SELECT * FROM QSYS2.SYSCOLUMNS SC WHERE SC.TABLE_NAME =
       'AAAKEY' AND
       SC.COLUMN_NAME = 'DUH')
THEN
EXECUTE IMMEDIATE SQLSTMT;
END IF;

END

[report a broken link by clicking here]