In article <[log in to unmask]>, [log in to unmask] says...
>
>Greetings all.  I'm a P/A at a Harvard Pilgrim Health Care of New
>England, based in Massachusetts, USA.  The main telephone provider in
>our service area is Bell Atlantic (formerly Bell Atlantic/Nynex).  BA
>is adding a new area code to certain exchanges in Massachusetts and we
>need to update all our databases that carry phone numbers, to correct
>the currently loaded (old) area codes.
>We use TurboIMAGE/XL (not sure of the version), QUERY vD.03.07 and
>SUPRTOOL v3.8.
>Can anyone provide guidance on any utilities/techniques that will
>search a database, scanning all the fields in all the datasets within
>it, looking for a certain value?  Preferably a wildcard such as
>@phone@ (a caseless search) that would cover instances of fieldnames
>such as 'phone', 'telephone', 'tele-phone', 'phone-no', 'phone#', etc,
>which I've seen searching source libraries.
>My goal is to identify all databases and datasets that need to be
>'zapped' with the new area code.  And the idea of scrutinizing all the
>JCL and COBOL source, and tying the reference back to the database
>doesn't seem very attractive.
>
>Any help would be very much appreciated.
>

Well surely you have copies of the DBSCHEMAs for all your databases in some
easy-to-find location, right?  If not, use Adager or DBGeneral (or even
SUPRTOOL I think) to create DBSCHEMA files for each database. Then use your
favorite editor, or MPEX, to scan through each DBSCHEMA file looking for
whatever string you are looking for.

--
Mark Landin
T. D. Williamson, Inc.
UNIX Sys. Admin
"If you take the smooth, you gotta take the rough" -- Rob Halford