CREATE PROCEDURE WWWTRN.UPDATE_MAG_SELECT_LIST (  )
    DYNAMIC RESULT SETS 1
------------------------------------------------------------------------
-- SQL Stored Procedure
------------------------------------------------------------------------
 BEGIN
    DECLARE seqnbr INTEGER DEFAULT 1;
    DECLARE counter  INTEGER;
    DECLARE c1 CURSOR FOR
        SELECT seq_nbr
        FROM   wwwtrn.mag_select_list AS magSelectList
        WHERE  list_id = -11
        ORDER  BY option_text_displayed;
    SET counter =  (SELECT COUNT (*) FROM  wwwtrn.mag_select_list WHERE  list_id = -11 );
    OPEN c1;
    FETCH c1 INTO  seqData;
    WHILE seqnbr<counter DO
        UPDATE magSelectList
               SET    seq_nbr = seqnbr
              WHERE CURRENT OF c1;
      SET seqnbr = seqnbr+1;
    END WHILE;
    CLOSE c1;
  END

Error:
WWWTRN.UPDATE_MAG_SELECT_LIST - Build started.
CREATE stored PROCEDURE returns -206.
WWWTRN.UPDATE_MAG_SELECT_LIST: 16: [IBM][CLI Driver][DB2/LINUXX8664] SQL0206N  "SEQDATA" IS NOT valid IN the context WHERE it IS used.  LINE NUMBER=16.  SQLSTATE=42703

WWWTRN.UPDATE_MAG_SELECT_LIST - Build failed.
WWWTRN.UPDATE_MAG_SELECT_LIST - Roll back completed successfully.