CREATE OR REPLACE PROCEDURE my_proc (...)
   LANGUAGE SQL
   BEGIN
    
      DECLARE sqlstate              CHAR (5) DEFAULT '00000';
      DECLARE sqlcode               INTEGER DEFAULT 0;
      DECLARE v_job_script          CLOB;
      DECLARE v_job_status          CHAR (1) DEFAULT 'F';
      DECLARE
         c_joblist CURSOR FOR
            SELECT script
              FROM   dmloperations  WITH UR;
      BEGIN

         OPEN c_joblist;
         FETCH FROM c_joblist
           INTO v_job_script;

         WHILE (sqlstate = '00000') DO
           job_exec:
            BEGIN
               /*Execution jobs script */
               DECLARE EXIT HANDLER FOR SQLEXCEPTION
                  EXECUTE IMMEDIATE v_job_script;
            END job_exec;

            COMMIT WORK;
            
            FETCH FROM c_joblist
              INTO  v_job_script;

         END WHILE;

         CLOSE c_joblist;
      END;
   END;

SQL0501N  The cursor specified in a FETCH statement or CLOSE statement is not open or a cursor 
variable in a cursor scalar function reference is not open.  SQLSTATE=24501