Re: utility sqr needed

[Rick_Creel@AONCONS.COM]

I would also be very interested in this utility.  Towards the end of this year
we will be upgrading from PS 7.53 to 8.4
ANYTHING that will make the job easier would be GREATLY appreciated !!!
Not looking forward to this :-(



|--------+------------------------->
|        |          "Beller, Jay"  |
|        |          <jbeller@LBISOF|
|        |          TWARE.COM>     |
|        |                         |
|        |          08/22/2002     |
|        |          10:21 AM       |
|        |          Please respond |
|        |          to sqr-users   |
|        |                         |
|--------+------------------------->
  >--------------------------------------------------------|
  |                                                        |
  |      To:     SQR-USERS@list.iex.net                    |
  |      cc:     (bcc: Rick Creel/IT/Aon Consulting)       |
  |      Subject:     Re: utility sqr needed               |
  >--------------------------------------------------------|





Steve - is this a utility that you're willing to share?

-----Original Message-----
From: Stephen Keen [mailto:stephen_keen@SQR-SERVICES.COM]
Sent: Thursday, August 22, 2002 10:19 AM
To: SQR-USERS@list.iex.net
Subject: Re: utility sqr needed


Yes I have Don.  It works for all SQR's except those that call the table
dynamically.


Steve


 -----Original Message-----
From:   Discussion of SQR, Brio Software's database reporting language
[mailto:SQR-USERS@list.iex.net]  On Behalf Of baileydl
Sent:   Thursday, August 22, 2002 8:50 AM
To:     SQR-USERS@list.iex.net
Subject:        utility sqr needed

Hi all,

I was wondering if anyone has written a sqr that will scan all the sqrs
and sqcs in a specified directory and create a listing of all the tables
used by each sqr in the directory.  We are in the process of upgrading
from PeopleSoft 7.6 to PeopleSoft 8.0 and need a quick way to analyze
existing sqrs and list tables currently being used by the sqrs.

Thanks for any help,

Don Bailey
don.bailey@vanderbilt.edu