|
View previous topic :: View next topic
|
| Author |
Message |
gylbharat
Active Member
.jpg)
Joined: 31 Jul 2009
Posts: 565
Location: Bangalore
|
|
|
|
Hi,
As SYSIBM.SYSROUTINES table contains a row for each routine defined in the system. Mostly the routines are written in SQL or COBOL.
My question is where we can see the source code of the routines? |
|
| Back to top |
|
 |
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
| Back to top |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009
Posts: 565
Location: Bangalore
|
|
|
|
Thanks for the reply peter. The table - SYSIBM.SYSROUTINES doesnt contain the Source code for the routines. There is another catalog table - SYSIBM.SYSROUTINES_SRC. But it does not contain source code for all the routines. According to the manual - "SYSIBM.SYSROUTINES_SRC table
Contains source for generated routines, such as those created by DB2 UDB for z/OS Procedure Processor DSNTPSMP". We are using DB2 V8 for Zos. |
|
| Back to top |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009
Posts: 565
Location: Bangalore
|
|
|
|
No one is replying...  |
|
| Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
Good spot...
Patience is a virtue.
PS. I have no idea myself. |
|
| Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
| Back to top |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009
Posts: 565
Location: Bangalore
|
|
|
|
| Still not clear... Want to know which catalog table stores the source_code for the DB2 stored procedure... |
|
| Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009
Posts: 1281
Location: Belgium
|
|
|
|
| column text in SYSIBM.SYSROUTINES |
|
| Back to top |
|
|
don.leahy
Active Member
Joined: 06 Jul 2010
Posts: 765
Location: Whitby, ON, Canada
|
|
|
|
Is the SP coded in SQL or in an external programming language?
If coded as an SQL procedure the source should be in SYSROUTINES_SRC.
If coded as COBOL or other programming language the source will likely be in whatever source library is used by your shop. |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10888
Location: italy
|
|
|
|
| Quote: |
Want to know which catalog table stores the source_code for the DB2 stored procedure...
|
I hope You realize that for odd requests not getting answers is pretty normal
remember...
replying is
on voluntary base
on our own time
the interest of the question asked
the knowledge/experience to provide a good reply
in this case most probably the last 2 apply
if You are really intereste better start searching Yourself
starting from ( for example ) here
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNSQK15/7.7?SHELF=DSNSHKA3&DT=20081120084907
| Quote: |
7.7.74 SYSIBM.SYSROUTINES table
7.7.75 SYSIBM.SYSROUTINESTEXT table
7.7.76 SYSIBM.SYSROUTINES_OPTS table
7.7.77 SYSIBM.SYSROUTINES_SRC table |
might be tables worth investigating |
|
| Back to top |
|
|
tp70227
New User
.jpg)
Joined: 20 Nov 2009
Posts: 3
Location: Hyd
|
|
|
|
Hi,
check in BMC tool with type as PR and give the name of the stored procedure. IF bmc give you information then give "DDL" in the cmnd and it will take you to the defination of the stored procedure. Sometimes some company write stored procedure as cobol db2 batch module and so check in your changeman or whtever you are using for the source. |
|
| Back to top |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009
Posts: 565
Location: Bangalore
|
|
|
|
| Thanks everyone... |
|
| Back to top |
|
|
apvardhini
New User
Joined: 23 Apr 2009
Posts: 20
Location: India
|
|
|
|
| Hi, when we download from BMC or create native sql stored procedure through SPUFI, the Sp is not indented properly. Why is it so and what is the workaround? |
|
| Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008
Posts: 1248
Location: Richfield, MN, USA
|
|
|
|
apvardhini,
Please start a new topic instead of adding onto a 3-yr old one. |
|
| Back to top |
|
|
|
|
