Skip to content

Instantly share code, notes, and snippets.

@richardschoen
Forked from BirgittaHauser/SearchSrcMbr
Created September 7, 2026 15:44
Show Gist options
  • Select an option

  • Save richardschoen/af763a4d837b88e888199d464638d5df to your computer and use it in GitHub Desktop.

Select an option

Save richardschoen/af763a4d837b88e888199d464638d5df to your computer and use it in GitHub Desktop.
How to search source physical file member for a specific String
It was just a question in a Forum: How to search (all) source physical file members for a specific string and list all those members
In this examples all source files beginning with "QSRC" in the "YOURSCHEMA" library are searched whether they include "String".
All Source Members that include "String" are returned
With a as (Select a.System_Table_Schema OrigSchema,
a.System_Table_Name OrigTable,
a.System_Table_Member OrigMember,
Trim(System_Table_Schema) concat '/' concat
Trim(System_Table_Name) concat '(' concat
Trim(System_Table_Member) concat ')' as OrigCLOBMbr
from Syspartitionstat a
Where System_Table_Name like 'QSRC%'
and System_Table_Schema = 'YOURSCHEMA')
Select OrigSchema, OrigTable, OrigMember
from a
Where Get_Clob_From_File(OrigClobMbr) like '%String%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment