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
 

 

Need info about Db2 stored procedures

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

New User


Joined: 13 Jul 2007
Posts: 10
Location: india

PostPosted: Mon Jul 16, 2007 4:54 pm    Post subject: Need info about Db2 stored procedures
Reply with quote

Can someone provide details of store procedure in DB2 ?
And how to invoke Db2 in mainframe..
Is with SPUFI or need to code cobol program etc

Regards,
Dhans.
Back to top
View user's profile Send private message

kussu
Warnings : 1

New User


Joined: 16 May 2007
Posts: 33
Location: India

PostPosted: Mon Jul 16, 2007 5:16 pm    Post subject: Re: Db2 store procedure
Reply with quote

Hi,

This is the information i know regarding DB2 stored procedures:

1. Load resides in the db2 area.
2. Called using the SQL statement.
3. Is very length sensitive, if mismatched gives -440 sql code.
4. Files cannot be used.
5. Cannot call a batch program but can call a stored procedure in it.
6. Depending on the db2 status the stored procedure can be down.
7. Any open system can call this.

stored procedure definitions can be stored in
SYSIBM TABLES
SYSYROUTINES:-
1. definition of the SP
2. checks in which region the SP Resides.
3. Result set information( data to be returned in the form of temporary
Tables.)
4. Result columns(number of columns For the result table.).
5. Commit on demand ( whether the changes have to be committed after
the execution of the stored Procedure).
SYSPARMS:
In this table the order of the parameters and the lengths of the parameters are declared.

Please open these tables and try to find the fields so that you can understand better.

And You can Invoke DB2 in both the ways
If You eloborate this Question, i can answer you in much better way
Back to top
View user's profile Send private message
hikaps14

Active User


Joined: 02 Sep 2005
Posts: 189
Location: Noida

PostPosted: Mon Jan 14, 2008 2:07 pm    Post subject: Reply to: Need info about Db2 stored procedures
Reply with quote

Hi ,

I am using SPUFI for accessing DB2.
I accessed table SYSROUTINES. I could not find any column having definition of SP.

Can't I view the definition of SP.

Thanks,
-Kapil.
Back to top
View user's profile Send private message
vebs

New User


Joined: 27 Oct 2007
Posts: 19
Location: UK

PostPosted: Tue Jan 15, 2008 12:09 am    Post subject:
Reply with quote

hikaps,

You can check for ROUTINETYPE = 'P' in SYSIBM.SYSROUTINES. The corresponding row will give you all particulars about SP that are used to define, like ASUTIME, LANGUAGE etc. Write all that and you have defination of SP.
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 Query on DB2 WLM stored procedures ashek15 DB2 8 Sun Feb 12, 2017 11:13 pm
No new posts Need info with DBRC recovery ashek15 IMS DB/DC 0 Mon Jan 23, 2017 6:43 am
No new posts Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 2 Tue Dec 06, 2016 4:38 am
No new posts IMS Database backup info ashek15 IMS DB/DC 14 Wed Nov 16, 2016 5:29 am
No new posts Regarding COBOL Stored Procedure opti... selvamsrinivasan85 DB2 4 Fri Nov 04, 2016 8:57 pm


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