Re: utility sqr needed

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

OK call me a dummy, but why do you say you could not use a GREP like search
to search SQC's?
I mean provided you have access that is.
-Alan.




                    Peter Clark
                    <PGCLARK@VAC-A        To:     SQR-USERS@list.iex.net
                    CC.GC.CA>             cc:
                    Sent by:              Subject:     Re: utility sqr needed
                    "Discussion of     Expire On:
                    SQR, Brio
                    Software's
                    database
                    reporting
                    language"
                    <SQR-USERS@lis
                    t.iex.net>


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





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