Re: find syntax for pf’s

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

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