By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,193 Members | 1,718 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,193 IT Pros & Developers. It's quick & easy.

Bookish Question Regarding DYNAMIC RESULT SETS

P: n/a
Dear Faculties,
I have a query on this statement..
===============================
CREATE PROCEDURE Check_Manage ( )
DYNAMIC RESULT SETS 1
==============================
I want to know the meaning of
===============================
DYNAMIC RESULT SETS 1
===============================
Db2Pdf telling
---------------------
indicate the number of result sets that it returns with the
DYNAMIC RESULT SETS clause.
---------------------
Means Number of cursor declare in this procedure is define through this clause?
Because there is no output parameter to return.
If not please explain me.
Regards
Arijit Chatterjee
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Yes it means how many result sets are returned by the stored procedure
.. Which invovles the number of open cursors .If the results sets
returned are dynamically changing , this clause will help in better
optimization of the stored procedure execution.

Thanks
Kiran Nair

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.