Re: utility sqr needed

[Alan Ljungberg <Alan.Ljungberg@CNPL.ENBRIDGE.COM>]

I think I realize what Peter is refering to.  A grep-type search will show
all table references in SQC's however SQR's do not necessarily call all
proceedures in included SQC's.  If you need that kind of detail you'd
probably need to write a script for it.
-Alan.



                    "Sengupta, Rajib
                    (CC-Contractor)"               To:     
SQR-USERS@list.iex.net
                    <Rajib.Sengupta@CONAGRA        cc:
                    FOODS.COM>                     Subject:     Re: utility sqr 
needed
                    Sent by: "Discussion of     Expire On:
                    SQR, Brio Software's
                    database reporting
                    language"
                    <SQR-USERS@list.iex.net
                    >


                    08/22/2002 10:19 AM
                    Please respond to
                    sqr-users





nope, i just used the wingrep and it shows the tables in SQC'c also and you
can get a printout also .
go to http://www.wingrep.com and download the software for free.
I am sure it will work fine with GREP in unix.
Rajib

-----Original Message-----
From: Peter Clark [mailto:PGCLARK@VAC-ACC.GC.CA]
Sent: Thursday, August 22, 2002 11:02 AM
To: SQR-USERS@list.iex.net
Subject: Re: utility sqr needed


Remember - UltraEdit (and for that matter, grep-like searches) will not
show
you the tables referenced in sqc's, which is why I had to develop my own
little utility.

>>> Al H <star111lists@MINDSPRING.COM> 2002/08/22 12:54:39 pm >>>
This type of search can also be performed by UltraEdit if you happen
to have it.  Great editor for SQR!

Search|Find In Files

http://www.ultraedit.com



On Thu, 22 Aug 2002 08:53:20 -0600, you wrote:

>I think we just covered this not long ago.
>In UNIX I'd use the GREP command.  It can easily be formatted to produce a
>list file.
>In windows you may want to look for a utility called WinGrep, which does
>the same basic thing.
>
>Do a search for  PS_* , you should get the results you want.  The only
>problems I can see is perhaps getting returns on tables mentioned in
>comments, In UNIX you can tell it to ignore comment lines.
>
>-Alan.
>
>
>
>                    baileydl
>                    <donl.bailey@VANDE        To:
SQR-USERS@list.iex.net
>                    RBILT.EDU>                cc:
>                    Sent by:                  Subject:     utility sqr
needed
>                    "Discussion of         Expire On:
>                    SQR, Brio
>                    Software's
>                    database reporting
>                    language"
>                    <SQR-USERS@list.ie
>                    x.net>
>
>
>                    08/22/2002 06:49
>                    AM
>                    Please respond to
>                    sqr-users
>
>
>
>
>
>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