Skip to content

Instantly share code, notes, and snippets.

@dancarlosgabriel
Forked from BirgittaHauser/SearchSrcMbr
Created September 4, 2022 13:53
Show Gist options
  • Save dancarlosgabriel/1362a44487289ada9b5b7d8f9a555f66 to your computer and use it in GitHub Desktop.
Save dancarlosgabriel/1362a44487289ada9b5b7d8f9a555f66 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