All,
It works fine when I return one ResultSet from a Procedure, but now when I return more than ResultSet. Below is my procedure:

create procedure show_employee_department()
dynamic result sets 2
begin
declare c_emp cursor with return for select * from employee;
open c_emp;

delcare c_dept cursor with return for select * from department;
open c_dept;
end

I get this error:
SQL0104N An unexpected token "delcare" was found following "loyee;
open c_emp;

". Expected tokens may include: "DECLARE

My Statement Termination character is '@'.

What am I missing here? Thanks in advance!

Look at the syntax diagram for creating a store procedure. The DECLARE CURSOR statements must all be at the beginning.

Try this:

Andy

Sequence of statements in a compound SQL statement are fixed.
For example, all DECLARE-CURSOR-statements should be placed before SQL-procedure-statements(including open cussor statement).

Please see more detaile in IBM DB2 9.7 for Linux, UNIX and Windows Information Center

Thanks guys.

Did anyone notice spelling mistake above ??


regards