The procedure can execute INSERT, UPDATE, DELETE. Options are NO SQL, CONTAINS SQL, READS SQL DATA, and MODIFIES SQL DATA. Be honest — if you say READS SQL DATA and then execute an UPDATE, you'll get SQLCODE -577.