Re: find syntax for pf’s

Hi Niels

Although this is very useful, I think the original poster is looking for contents of the columns, not just column names. Here is his original question -

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.

I do see, on looking again at that, where it might suggest column names, but I think he meant names of people or things.

Have I missed something?

Regards
Vern

On 2/24/2021 4:15 AM, Niels Liisberg wrote:

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]' );