Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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: 6967
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 SNMP trap from Mainframe bipinpeter Compuware & Other Tools 6 Wed Apr 26, 2017 3:05 pm
This topic is locked: you cannot edit posts or make replies. Mainframe Opening in Allianz India- T... Rajesh Gopinathan Mainframe Jobs 0 Wed Apr 19, 2017 11:33 am
No new posts FTP from Mainframe to Unix - with CRLF vasanthz All Other Mainframe Topics 7 Thu Mar 23, 2017 5:12 am
No new posts Want to pull the job log into a Mainf... Jishu Mukherjee Compuware & Other Tools 9 Tue Mar 21, 2017 4:48 pm
No new posts Innovations in Your Mainframe Sort Arun Raj PC Guides & IT News 4 Wed Mar 15, 2017 10:38 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us