Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Web connectivity with Mainframe DB2 using Stored procedures

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
sajjan jindal
Warnings : 1

New User


Joined: 09 Sep 2007
Posts: 60
Location: india

PostPosted: Thu Jul 02, 2009 12:02 pm    Post subject: Web connectivity with Mainframe DB2 using Stored procedures
Reply with quote

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
View user's profile Send private message

ashimer

Active Member


Joined: 13 Feb 2004
Posts: 551
Location: Bangalore

PostPosted: Thu Jul 02, 2009 4:19 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Thu Jul 02, 2009 4:36 pm    Post subject:
Reply with quote

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
View user's profile Send private message
bhairon singh rathore

New User


Joined: 19 Jun 2008
Posts: 91
Location: banglore

PostPosted: Thu Jul 02, 2009 6:07 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How do I create a mainframe monitorin... anjali.bisht All Other Mainframe Topics 4 Fri Sep 01, 2017 2:20 pm
No new posts Mainframe dataset split purushottam DFSORT/ICETOOL 13 Tue Aug 29, 2017 12:28 pm
No new posts FTP data transfer from PC to Mainfram... AJAYREDDY All Other Mainframe Topics 8 Wed Aug 23, 2017 9:59 pm
No new posts Allianz Technology - Mainframe 3+ Yea... sooraj184 Mainframe Jobs 0 Mon Jul 31, 2017 2:17 pm
No new posts Mainframe Opening in Chennai ( 2 to 4... muralikrishnan_new Mainframe Jobs 0 Tue Jul 18, 2017 2:20 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us