1. I use the following command to create a file.
SEQUEL/DSPVIEWD VIEW(your_library/*ALL) ATTRIB(*ALL) TYPE(*SQL) OUTPUT(*OUTFILE) OUTFILE(your_library/afilename)
2. Create a view over the new file you created. The field called SQL is sequel statement for a view.
Your Where clause would look something like this...
Where SQL contains 'file name your searching for"... etc.
Originally Posted By [email protected]