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