View previous topic :: View next topic
|
Author |
Message |
sajjan jindal Warnings : 1 New User
Joined: 09 Sep 2007 Posts: 60 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. |
|
Back to top |
|
|
ashimer
Active Member
Joined: 13 Feb 2004 Posts: 551 Location: Bangalore
|
|
|
|
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... |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
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. |
|
Back to top |
|
|
bhairon singh rathore
New User
Joined: 19 Jun 2008 Posts: 91 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. |
|
Back to top |
|
|
|