Scan though streamfiles

Search_through_IFS_files.sql

-- Search thourhg IFS files that include a specific text (sequence of characters)
-- In the following example the '/home/Hauser' directory is searched for streamfiles with the extender .json
-- All these streamfiles are searched for 'FirstName'. 
-- All streamfiles including 'FirstName' are returned.

-- Attention: Get_CLOB_From_File must run under commitment control!
Select Path_Name, Get_Clob_From_File(Path_Name) "IFS File Content"
  From Table (Qsys2.Ifs_Object_Statistics(Start_Path_Name     => '/home/Hauser', 
                                          Subtree_Directories => 'YES',
                                          Object_Type_List    => '*ALLSTMF')) x
  Where     Right(Trim(Path_Name), 5) = '.json'
        and Get_Clob_From_File(Path_Name) like '%FirstName%'
  Order By Path_Name      
  With cs;