Re: find syntax for pf’s

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

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