Difference between DYNAMIC RESULT SET and RESULT SET

Neharao · #1 (**permalink**) 03-17-11, 04:36

Can some one explain me if we really have a difference between mentioning DYNAMIC RESULT SET and RESULT SET in DB2 Stored Procedures.

And also will it error out if I have specfied DYNAMIC RESULT SET 3 and Declared 4 CURSORS in the Procedure with "WITH RETURN TO CLIENT FOR" Clause.

sathyaram_s · #2 (**permalink**) 03-17-11, 08:58

Quote:

Originally Posted by Neharao

Can some one explain me if we really have a difference between mentioning DYNAMIC RESULT SET and RESULT SET in DB2 Stored Procedures.

Technically none
DYNAMIC RESULT SETS is the correct db2 syntax
An equivalent is "RESULT SETS" that has been provided for compatibility with previous versions of DB2 and with other database products

Quote:

Originally Posted by Neharao

And also will it error out if I have specfied DYNAMIC RESULT SET 3 and Declared 4 CURSORS in the Procedure with "WITH RETURN TO CLIENT FOR" Clause.

Please try an example yourself and let us know ;-)

HTH