Web connectivity with Mainframe DB2 using Stored procedures

sajjan jindal · New User Joined: 09 Sep 2007 Posts: 56 Location: india

Hi all,

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.

ashimer · Posted: Thu Jul 02, 2009 4:19 pm Post subject:

Google and you will get lots of examples ... basically drivers are used for frontend and backend connection ... in some cases there could be a middleware involved like MQ...

dbzTHEdinosauer · Posted: Thu Jul 02, 2009 4:36 pm Post subject:

Not the greatest source for info, but for links is IBM Tech Journal
and of course the IBM REDBOOK site. There is a search button in upper right.

bhairon singh rathore · New User Joined: 19 Jun 2008 Posts: 70 Location: banglore

if frontend is java you can call SP directly Via its External name by passing input parameter into it and output of SP is retrieved as a result set.