Re: find syntax for pf’s

I see you asked about using *ALL - that's available in a filter in RDi, but you probably don't want to search IBM files - so the User libraries filter would be your thing - I didn't try it, so don't know if you can select only data files. But there is a way to do it - when you open User libraries, select them all individually - click on the first one, go to the bottom, hold the shift key and click on the last one, then press enter - that should give you choice of source or data.

Now the only thing is, does it have an export to CSV or text file or whatever.

Cheers
Vern

On 2/20/2021 6:48 PM, Vern Hamberg wrote:

FNDSTRPDM can be run against a member or all members in a file. Now that sounds really limiting, and it kind of is - but not so bad as it has to be.

The best tool, I think, for data files is RDi - you can use the Find string... function on everything from a member all the way up to filters - including things like Library list or any filter you create - this is nice - I tried a couple things and found that maybe doing this on a filter like Library list might not let you choose whether to search source or data or both. But you can open any filter, then select the libraries you want to search in, select data or source or both, and it'll go through everything.

I did see it say there was some kind of error along the way, all I had to do was say to keep going - but I think you have to be there to watch the whole thing.

You get a display with file name, member name, and record number where your search text was found. I forgot to see if there is a way to export the results.

ISphere has a fantastic search but only for source that I recall. It has an export of the results to a spreadsheet - but for your purpose, RDi Find string... might be pretty good.

You CAN use PDM, open a library, filter to PF-DTA only (F17 is your friend), put 25 on one to get an idea of parameter settings - you want *NONE for action and tell it to print the results - I forget the details. Then F12 out of that, put 25 on the 1st one again, press F13 to put it on all the files, and put the parameters you want on the command line - then press enter and you'll get the whole bunch pretty well - might still get errors you can ignore or restart - things like the record length is less than the length of the string you are looking for.

I forget if there is one spooled file per member or per file - you'd need to convert and combine afterwards.

HTH
Vern

On 2/20/2021 1:59 PM, Jack Woehr wrote:

FNDSTRPDM

On Sat, Feb 20, 2021 at 12:54 PM frank boke <fboxxx1958@xxxxxxxxx> wrote:

Hey folks I’m trying to find everywhere in all my pf’s where a certain
string is and the string is a name.  Does anyone know the syntax that I
have to use for that? ive looked at qsh find but cant get it to work.
thanks, frank