× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.