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
 

 

how to execute stored procedure in mainframe

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

Active User


Joined: 07 May 2005
Posts: 110
Location: hyderabad

PostPosted: Tue Aug 22, 2006 12:02 pm    Post subject: how to execute stored procedure in mainframe
Reply with quote

hi,

anyone please update me immediately about stored procedures procedure.

I want to execute stored prodecures in Mainframes, which are already developed in DB2 UDB[universal Database]. There is no concern of COBOL, purely stored procedures.
please send me the details as early as possible.

regards

Nagesh
Back to top
View user's profile Send private message

ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Tue Aug 22, 2006 12:19 pm    Post subject:
Reply with quote

Have you considered reading the fina manual?

O.
Back to top
View user's profile Send private message
Muthukumar.PLindia

New User


Joined: 03 Jul 2006
Posts: 51
Location: Chennai

PostPosted: Fri Sep 01, 2006 7:04 am    Post subject: hi offer
Reply with quote

the manual is fine.. It states that a stored proc should have 1 or more sal statements and it needs some programming codes for logical processing. So cant we write stored procedures as we write in oracle, only using sql and plsql commands


If we are writing such type of pure sql statements compiled and executed by DB2 itself without ht eintervention of our os.. then how can we do it in mainframes,
Back to top
View user's profile Send private message
Muthukumar.PLindia

New User


Joined: 03 Jul 2006
Posts: 51
Location: Chennai

PostPosted: Fri Sep 01, 2006 7:07 am    Post subject: Re: hi offer
Reply with quote

Muthukumar.PLindia wrote:
t

If we are writing such type of pure sql statements compiled and executed by DB2 itself without ht eintervention of our os.. then how can we do it in mainframes,




the last para has many spelling mistakes.. please kindly bear me :0 It should be like this


If we are writing such type of pure sql statements compiled and executed by DB2 itself, without the intervention of our os.. then how can we execute it in mainframes
Back to top
View user's profile Send private message
stly
Warnings : 1

New User


Joined: 25 Jul 2005
Posts: 93

PostPosted: Fri Sep 01, 2006 12:20 pm    Post subject: Re: how to execute stored procedure in mainframe
Reply with quote

u can execute storedproc using DB2connect
Back to top
View user's profile Send private message
surya_pathaus

Active User


Joined: 28 Aug 2006
Posts: 110

PostPosted: Fri Sep 01, 2006 2:01 pm    Post subject:
Reply with quote

Hi

If you want to test Stored Proc in Mainframe not using any DB2TOOLS like DB2 CONNECT said by stly, you have to modify the store proc little bit.

1) Remove all CBL statement which we add in storeproc.
2) add one output file and write the record which are inserting into temporary table. (dont remove any code related to temporary table just add one write statement before or after inserting into temporary table)
3) prepare one run jcl and execute the storeproc like cobol program.
4) you will get the output into a file which is inserted in temporay table.
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 Produce Mainframe Dash Board Reports ... sdcarlson53 All Other Mainframe Topics 2 Thu Jan 05, 2017 11:01 pm
No new posts Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 2 Tue Dec 06, 2016 4:38 am
This topic is locked: you cannot edit posts or make replies. Urgent Mainframe Requirments (2-10 yr... Shankar779 Mainframe Jobs 0 Sun Nov 27, 2016 1:48 pm
No new posts Regarding COBOL Stored Procedure opti... selvamsrinivasan85 DB2 4 Fri Nov 04, 2016 8:57 pm
No new posts Access SQLCA fields inside a stored p... gangapd DB2 4 Thu Oct 27, 2016 10:20 am


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