Re: 2 files lookup

What I've done is written a crude cross referencing system to handle stuff like this. I have a file (sourcepf) that contains the name of every source physical file on our system, and the library that it's in. I've written two programs that we run every night. The first reads thru sourcepf, and then executes dspfd on the source physical file type(*mbrlist) outfile(mbrlistf). The second program reads thru the mbrlistf file. It checks field MLSEU2 to determine that the member is a program, and that it exists as an object on the system. If both tests are passed, dsppgmref is executed to outfile(pgmxreff).

A third program filexref allows a user to enter a file name. It then queries pgmxreff and returns a list of programs that use that file, along with how each program uses that file (see whfusg in pgmxreff). I'm still working on this last part. I'd like to add wild card functionality to the query.


CONFIDENTIALITY NOTICE: This email message is private,
confidential property of the sender, and the materials
may be privileged communications intended solely for
the receipt, use, benefit, and information of the intended
recipient indicated above. If you are not the intended
recipient, you are hereby notified that any review,
disclosure,distribution, copying or taking of any
other action in reference to the contents of this message
is strictly prohibited, and may result in legal liability
on your part. If you have received this message in error,
please notify the sender immediately and delete this
message from your system. We believe that this email
and any attachments are free of any virus or other defect
that might affect any computer system that it is received
and opened in, however, it is the responsibility of the
recipient to ensure that it is virus free and the sender
accepts no responsibility for any loss or damage.