pvsbandi
asked on
DB2 Out Parameters with result Set
Hi,
I have a stored procedure to write in DB2 and was planning to bring the result as result set, using a cursor with return to the caller.
My colleague was suggesting that i write it with a combination of out parameters and result sets.
Is it possible to have both result set and out parameters to contain in one stored procedure?
I have a stored procedure to write in DB2 and was planning to bring the result as result set, using a cursor with return to the caller.
My colleague was suggesting that i write it with a combination of out parameters and result sets.
Is it possible to have both result set and out parameters to contain in one stored procedure?
ASKER
Hi Kent,
Basically, there are different sections on my report. Some of the sections have only 1 value at any time.
But there are some other sections, which can have repeating details.
So, my lead is asking me to have the one -one value fields as OUT parameters and the ones, which might repeat, to have as the result sets.
Basically, there are different sections on my report. Some of the sections have only 1 value at any time.
But there are some other sections, which can have repeating details.
So, my lead is asking me to have the one -one value fields as OUT parameters and the ones, which might repeat, to have as the result sets.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank You!
Sure. You can do both. If you'll explain your project a bit perhaps we can suggest a reasonable solution.
Kent