Error building a Stored Procedure

Hello all I am new to this environment and in process of creating the following procedure.
I am getting errors could some one help me.
Thanks

CREATE PROCEDURE SESS.GETDATA ( IN SESSID varchar(50),
                                   IN KEYNAME varchar(50),
                                   IN OPERATION varchar(50),
                                   IN L_EVENT varchar(50),
                                   IN PARENTKEY varchar(50) )
    SPECIFIC SESS.GETDATA
    DYNAMIC RESULT SETS 1
    LANGUAGE SQL

P1: BEGIN
    -- Declare cursor
    DECLARE cursor1 CURSOR WITH RETURN TO CALLER FOR
        SELECT KEY_VAL
        FROM SESS.SESSION;

    -- Cursor left open for client application
    OPEN cursor1;

END P1


when i use SPB, it's giving me SQL091N The SQL Statement failed because of a
non-severe system error.  Subsequent statements can be processed (Reason "Error while generating C source code".)
SQLSTATE = 58004
It was giving me a different error if I use Command Center