RE: Way to search Stored Procedures?

iSeries Navigator  

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of DebbieKelemen
Sent: Wednesday, January 10, 2007 12:21 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: Way to search Stored Procedures?

I was looking for more of a GUI approach for this.  Plus I couldn't find
SYSPROCS on my system.  But thanks for trying.

Deb


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Elvis Budimlic
Sent: Wednesday, January 10, 2007 10:09 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: Way to search Stored Procedures?

Do STRSQL and peruse these SQL views:

SYSPROCS - Stored procedures
SYSFUNCS - UDFs
SYSROUTINES - both SPs and UDFs

Elvis

Celebrating 10-Years of SQL Performance Excellence

-----Original Message-----
Subject: Way to search Stored Procedures?

I'm not sure this is the correct list to ask this on but here goes.

We have had group of contractors working assisting our web developer.
We need to make sure some changes were made to the code.  Is there a way
to search each of the stored procedures without opening each one a doing
a find for the string of data we are looking for?

Debbie Kelemen



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.