Re: Utility for parsing SQRs

[Scott Barnes <sbarnes@MAIL.WESLEYAN.EDU>]

Jay,

Just try the simples way.  I love a challenge for writing an SQR. But
creating a program for this task is a waste of time.

Do you have access to the source code directory? If so create a sub
directory in that directory.
Open windows explorer and find files containg text :JOB  (Use the exact
table name no case)
Save a copies of all those sqrs in the temp directory.
Then search that temp directory for all the sqrs containg text COMPANY

This will give you a hi percentage list of the suspects.

Why spend time writing a program for something you can do in 2 minutes
using windows explorer.

My 2 cents.

Scott





At 02:35 PM 8/13/02, you wrote:
>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


----------

Scott A Barnes
Programmer/Analyst
Wesleyan University
North College
860-685-2807


----------
Lottery: A tax on people who are bad at math!