Re: utility sqr needed

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

Sorry if I insulted you Peter it was not my goal, only a simple question.
It was my understand that was the function of user groups.
-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
                    11:40 AM
                    Please respond
                    to sqr-users





No, best you call me the dummy. The GREP (general search and replace)
function that I learned in my Introduction To UNIX course 15 or 16 years
ago - and haven't used since - is (or has become over the years) obviously
a lot more sophisticated than I thought, if it can interpret the #include
statements in an SQR and include searches for tables within those SQC files
and still report them under the calling SQR's table list.

However, I do use UltraEdit on a daily basis and am aware that this
processing is beyond its capability.

After all, what good is a listing that lists, for example ...
Table_A and Table_B accessed in the main code of SQR-1
Table_C and Table_D accessed in the main code of SQR-2
Table_X and Table_Y accessed in the code of SQC-1
when you have no idea whether SQC-1 is included by SQR-1 or SQR-2 or both
or neither when what is needed is a listing that reports that (for example)
Table_A and Table_B and Table_X and Table_Y are referenced in the code of
SQR-1 while SQR-2 references only Table_C and Table_D.

I apologize to the UNIX gurus.

>>> Alan Ljungberg <Alan.Ljungberg@CNPL.ENBRIDGE.COM> 2002/08/22 1:35:31 pm
>>>
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.