Re: Utility for parsing SQRs

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

Not sure how to do this on windows but it's not that hard to do in UNIX.
Ask your UNIX people, or handy UNIX reference book, about the "grep'
command.  If you pipe a few commands together you should find what you
need.

Something like this:

grep -i *.sqr  'table_name | grep -il 'column_name' > output-file.lis

...should dump the output to a file.  You may have to play around with the
flags a bit but what do you expect this is a SQR group not UNIX.  If you
get stumped post on a UNIX group they'll have it for you pretty fast.

-Alan.



                    "Beller, Jay"
                    <jbeller@LBISOF        To:     SQR-USERS@list.iex.net
                    TWARE.COM>             cc:
                    Sent by:               Subject:     Utility for parsing SQRs
                    "Discussion of      Expire On:
                    SQR, Brio
                    Software's
                    database
                    reporting
                    language"
                    <SQR-USERS@list
                    .iex.net>


                    08/13/2002
                    12:35 PM
                    Please respond
                    to sqr-users





We're trying to find a utility that would allow us to search through all
SQRs (either on Unix or Windows) looking for references to a specific field
from a specific table.

For example, find all programs that reference the COMPANY field in the JOB
table.

It's not a simple search, which could identify programs that reference the
field name COMPANY, but not which table the reference relates to.

Before we try developing our own, we thought we'd ask if anyone's already
developed this type of utility.

Thanks.

jay