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
 

 

Using Stored procedures in Mainframe/DB2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
View previous topic :: :: View next topic  
Author Message
cijojosev

New User


Joined: 16 Dec 2005
Posts: 4
Location: Mumbai

PostPosted: Fri Dec 16, 2005 2:54 pm    Post subject: Using Stored procedures in Mainframe/DB2
Reply with quote

Hi friends,
i am new here.i want to know how to call a stored procedure in a cobol program.
the requirement is that i need to insert some data into a Midrange Database(Distributed side) from mainframe.the data in tha mainframe part is in tha form of flat file.the stored procedure will be created by the Distributed side midrange DBA.we will have to call the stored procedure using a cobol program and insert the data into the Midrange Database.

we havint used the stored procedures yet
so can anyone help out on how to deal with it on the cobol part
Back to top
View user's profile Send private message

DavidatK

Active Member


Joined: 22 Nov 2005
Posts: 700
Location: Troy, Michigan USA

PostPosted: Fri Dec 16, 2005 9:09 pm    Post subject:
Reply with quote

Friend cijojosev,

I think you will have better luck getting an acturate answer to your quesry in the DB2 forum. I would repost this there.

I'll look for the query the the DB2 forum and try to give you some basics on DB2 Stored procedures.

A DB2 Stored Preocedure is nothing more than a subroutine with a few additional considerations. NBD
Back to top
View user's profile Send private message
k_vikram07

New User


Joined: 23 Nov 2005
Posts: 35

PostPosted: Sun Dec 18, 2005 1:14 pm    Post subject:
Reply with quote

Hi Cijo,

You can use the sql statements to run it
YOu need to know the parameters to be passed to the stored proc.

EXEC SQL
CALL stoproc(:inparm1,:inparm2,:outparm1,:outparm2)
END-SQL.

Do the normal sql checks as usual.

The first thing we need to know is, what are the parameters it needs, and what are the things it return.
Back to top
View user's profile Send private message
cijojosev

New User


Joined: 16 Dec 2005
Posts: 4
Location: Mumbai

PostPosted: Mon Dec 19, 2005 4:23 pm    Post subject: Using Stored procedures in Mainframe/DB2
Reply with quote

hi,

thanks k_vikram07 & DavidatK,i am looking for a little more detailed data on that . as DavidatK said i have posted it on DB2 also.however i am trying with what i have recived.
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 -> COBOL Programming 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