I work in a project which has Web as well as Mainframe part ( I believe most of the projects work the similar way or will be soon upgraded in this fashion).
The stored Procedure are coded in COBOL with embedded SQL (DB2) on mainframes.
These are called from the Web. For example theres an employee database and my the web page allows me to select the dept name for which i want to generate a report listing all the employees and there details in the data base.
I select a particular department via the web page and this is passed to the parameters (Linkage section) in the Cobol - Db2 stored procedure. This Stored procedure runs the queries (and Cursors) , gets the data and populates a temporary table. This temporary table is returned to web (Donno how).
This is the process and i want to know how is the procedure triggered on mainframe. I would like to know the process for these kind of projects. Please help me if any one has worked in this kind of project.