Why is this simple SQL SP not returning any results? It is running fine
(gives RC=0) but just not returning the result set.
CREATE PROCEDURE SQLSP9
(
IN PWORKDEPT CHAR(3)
, OUT v_sqlcode INTEGER
, OUT v_sqlstate CHAR(5)
)
DYNAMIC RESULT SETS 1
LANGUAGE SQL
BEGIN
DECLARE SQLCODE INTEGER DEFAULT 0;
DECLARE SQLSTATE CHAR(5) DEFAULT '00000';
DECLARE V_DUMMY CHAR(1);
DECLARE C1 CURSOR FOR SELECT FIRSTNME FROM db2admin.EMPLOYEE WHERE
WORKDEPT = PWORKDEPT;
DECLARE EXIT HANDLER FOR SQLEXCEPTION
BEGIN
SET V_SQLCODE = SQLCODE;
SET V_SQLSTATE = SQLSTATE;
END;
OPEN C1;
END
@
TIA
Raquel.