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
 
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 Identifying Interfaces in CICS/mainframe Ashishpanpaliya CICS 5 Fri Oct 13, 2017 3:21 pm
This topic is locked: you cannot edit posts or make replies. Rexx to execute spool commands upendrasri CLIST & REXX 5 Wed Oct 04, 2017 6:54 am
No new posts Execute JCL step based on the content... sprikitik JCL & VSAM 2 Tue Oct 03, 2017 10:03 am
This topic is locked: you cannot edit posts or make replies. Rexx to execute spool commands upendrasri CLIST & REXX 47 Fri Sep 29, 2017 1:08 pm
No new posts Mainframe scheduling tool ddhar Compuware & Other Tools 2 Wed Sep 27, 2017 12:48 am

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