Re: grep question - maybe

Thanks John, but i have too many and large files to do that.

i have gotten this so far, but its not returning the information i know exists:

DSPFD FILE(datalibray*ALL)
TYPE(*MBRLIST)
OUTPUT(*OUTFILE)
OUTFILE(TIM/ALLFILES)

db2 "SELECT '/QSYS.LIB/' || trim(MLLIB) || '.LIB/' || trim(MLFILE) || '.FILE/' || trim(MLNAME) || '.MBR' FROM tim.allfiles
WHERE MLSEU=' ' and MLFTYP='P'"
| grep 'JUDY'


i know a huge files contains JUDY, but its not returning that as a result.

On 1/16/2016 1:33 PM, JRusling@xxxxxxxxxxx wrote:

I assume you mean 'in a library' since you indicate 'physical' files.

I was tasked to search all files in a library for a specific string.

The requestor couldn't tell me which files or fields to search in.

I ftped all physical files from said library to my pc, this resulted in
readable (searchable) text fields but not readable number fields.
(but i wasn't searching those)

Then i used Textpad (pc text editor) to search the folder containing the
downloaded files.

This worked for my purposes.

John

i want to scan all physical files in a directory for a specific string.

<br />
The information in this email is confidential and may be legally privileged.
It is intended solely for the addressee. Access to this email by anyone else is
unauthorized. If you are not the intended recipient, any disclosure, copying,
distribution or any action taken or omitted to be taken in reliance on it, is
prohibited and may be unlawful.