× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Hello Birgitta,

Am 30.06.2023 um 07:29 schrieb Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx>:

Can be done with SQL:
The following SQL Statement lists all IFS files under '/home/Hauser' (including all Subtrees) that contain 'whatever' in the content.
The only requirement is the SELECT statement needs to be executed under commitment control:

Select Path_Name
From Table (Qsys2.Ifs_Object_Statistics(Start_Path_Name => '/home/Hauser',
Subtree_Directories => 'YES',
Object_Type_List => '*ALLSTMF')) x
Where Lower(Get_Clob_From_File(Path_Name)) like '%whatever%'
Order By Path_Name ;

I don't expect this to run perceivable faster. I think the main issue is the IFS layer, not the access method.

But let's see the response from Mohan.

:wq! PoC


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.