Re: find syntax for pf’s

What about using SQL and regular expressions together - it runs across all
libraries/files/fields aka. schemas/tables/columns

Here I use this feature to list all columns with digits

Select *
from qsys2.syscolumns
where regexp_like (column_name , '[0-9]' );


On Sun, Feb 21, 2021 at 1:31 AM x y <xy6581@xxxxxxxxx> wrote:

No and no. I'm pretty sure no tool exists for your specific requirement
and you'll have to roll your own if you want a fully-automatic solution.
The need for *ALL libraries complicates things if you're not comfortable
with dealing with libraries, files, and members.

If you're looking for a small number of instances, I'd start with this--
DSPFD FILE(*ALL/*ALL) TYPE(*ATR) OUTPUT(*OUTFILE) FILEATR(*PF)
to get a file of all the PF's. Then you'll have to call FNDSTRPDM and pass
the file/library/search string, with an option of *DSP (display), for every
row in your DSPFD output file. Run this interactively and the job will
stop and display every instance-but if you're only looking for one, you're
done.

Plan B: use QCLSCAN. This API has some handy options but a solution is
more complicated.

Plan C: unfortunately, RDi appears to not have a handy way to do this, so
this plan is kaput.

Option D: you could use WRKOBJPDM to find files with the PF-DTA attribute
and then set up a custom option calling FNDSTRPDM with PRTMBRLIST(*YES).
You type the FNDSTRPDM option on the first row of the WRKOBJPDM panel,
press F13, and stand back. You'll get a list of files/members containing
your string and then you can use DSPPFM to file the exact location. This
is a library-by-library approach and probably the most time-effective
unless you're scanning hundreds of libraries. Set up multiple sessions so
you can have multiple obs running and you'll be done.

Option E: there probably is a way to use EGREP, a PASE (Unix style)
function, to do this but I'm rusty and defer to the professionals.
Something like this:
egrep -r "MyFindString" /qsys.lib/datalib.lib
These commands can pipe (transfer) lists of data to each other and they're
extremely handy.

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

is that just for source files and can i use *all for the lib?



On Sat, Feb 20, 2021 at 3:00 PM Jack Woehr <
jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx>
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

--

Jack Woehr, IBM Champion 2021

<

https://www.youracclaim.com/badges/528d23d6-087f-4698-8d17-d59688106ac4/public_url

Absolute Performance, Inc.

12303 Airport Way, Suite 100

Broomfield, CO 80021



NON-DISCLOSURE NOTICE: This communication including any and all

attachments is for the intended recipient(s) only and may contain

confidential and privileged information. If you are not the intended

recipient of this communication, any disclosure, copying further

distribution or use of this communication is prohibited. If you

received

this communication in error, please contact the sender and

delete/destroy

all copies of this communication immediately.

--

This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx

To subscribe, unsubscribe, or change list options,

visit: https://lists.midrange.com/mailman/listinfo/midrange-l

or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx

Before posting, please take a moment to review the archives

at https://archive.midrange.com/midrange-l.



Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription

related

questions.



Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com