Re: utility sqr needed

[Peter Clark <PGCLARK@VAC-ACC.GC.CA>]

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.