Returning a COBOL result set to WEB application

gerry sepulveda · Posted: Tue Jun 22, 2010 8:59 pm

I'm not really sure if this topic was discussed earlier but here goes.
I have been tasked to create a stored procedure that will return a result set to a web application.
I do know the result set will have a max of 25 rows with approx 10 columns based on account number.
I plan on using 2 sub-modules to produce the date and return the information to the stored procedure.
From information I already have, the stored procedure must declare a temp table, open a cursor to the temp table for the web app to fetch.

My specific questions are:
1. At what point would I call the sub-modules to load the temp table?
2. Would the linkage section variables be the temp table or the individual columns.
3. would the sub-modules be call with each fetch from the web app?

Any information is helpful

Thanks
Gerry

dbzTHEdinosauer · Posted: Tue Jun 22, 2010 10:04 pm

One of the following Redbooks may be of some assistance:

DB2 for Z/OS Application Topics

DB2 Vsn 9 for Z/OS Stored Procedures

DB2 for Z/OS Stored Procedures

Latest Redbooks
you can use the above url to perform a search on web related topics.

gerry sepulveda · Posted: Tue Jun 22, 2010 11:02 pm

I've gotten the basic information from the RedBooks mentioned however, the basic information doesn't explain the question as to when to call the sub-modules, when the cursor is called, etc..

I have seen information about loading the temp table, that piece is self-explanatory.

Thanks