Hi Santosh
If you're at V8.1 UDB LUW or higher, SYSCAT.ROUTINEDEPS will have all the
information you're looking for.
Regards
Alex Levy
Sustainable Software Ltd
http://www.sustainablesoftware.net


-----Original Message-----
From: Patel Santosh
[mailto:db2udbdba-ezmlmshield-x8575891.[Email address protected]
Sent: 18 February 2008 13:22
To: LazyDBA Discussion
Subject: RE: DB2 query


Hi Edwards,

I started with it... and the database has 191 procedures ...and I get
the entire procedure text in TEXT column,

I'm not sure how to spool it so that I can at lease do a copy-paste into
an [don't laugh here] excel sheet. picking table information from 191
procs!! why do I get into all this!!!

-Santosh

-----Original Message-----
From: Edwards Ed
[mailto:db2udbdba-ezmlmshield-x73168544.[Email address protected]
Sent: Monday, February 18, 2008 6:44 PM
To: LazyDBA Discussion
Subject: RE: DB2 query

Look at the "text" column in syscat.procedures


-----Original Message-----
From: Edwards Ed
[mailto:db2udbdba-ezmlmshield-x74943415.[Email address protected]
Sent: Monday, February 18, 2008 8:10 AM
To: LazyDBA Discussion
Subject: RE: DB2 query

Try syscat.procedures




Please take a few minutes to provide feedback on the quality of service
you received from our staff. The Department of Education values your
feedback as a customer. Commissioner of Education Dr. Eric J. Smith is
committed to continuously assessing and improving the level and quality
of services provided to you.Simply use the link below. Thank you in
advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: Patel Santosh
[mailto:db2udbdba-ezmlmshield-x37625818.[Email address protected]
Sent: Monday, February 18, 2008 8:06 AM
To: LazyDBA Discussion
Subject: DB2 query

Hi There,

I'm trying to get information from procedures in a database... I'm
actually trying to retrieve table names that are being used in that
procedure and also objects that are referencing that procedure.

I understand that SYSCHECKS and syscat.references etc. talk only about
constraints that refer to tables, but is there some system catalog table
where I can find about objects refering to the procedures in
syscat.procedures ?

-Santosh


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




DB2 & UDB email list listserv db2-l LazyDBA home page