IBM MAINFRAME HELP & SUPPORT FORUMS

srinivasr · Joined: 22 Feb 2007 Posts: 1 Location: Chennai

Hi,

Is it possible to add header and trailer to stored proc output (result set) without using any temporary table?

I have a cursor which returns more than one row for a set of input parms.
I would like to add a header (can be formed from input parms) and trailer (constant string) to the result set. Problem here is, input parm can have more than one value for a particular variable. Hence, stored proc result will be in sets. I need to add header and trailer to each set.

please advise if this is possible with multiple SQL statements combined with UNION operator (within cursor declaration). Any other suggestion would also be helpful.

PS: the stored proc is called by Java.

Thank you,
Srinivas R