× 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.



This thread has really caught my attention - due to a MAJOR problem we have had since the New Year
We started having Mutex waits for users in the warehouse using web service calls to an outside company that would supply us with the correct courier, labels etc.
This was killing us
From a couple of seconds for a response - it went to 15 to 20 minutes per response
To cut a LOOOOOOOOOOOOOOOOOOOOOOOOOONG story short, the immediate problem was that we were mimixing the ifs (when we don't really need to) PLUS one ifs directory has over 7.5 million files, accumulated in 8 months

When I looked at the results of our ifs purge job, I discovered that this particular directory was NOT being purged
We have since included other directories into our ifs purge process, and we hope that because the warehouse does not work from Friday night to Sunday morning, this will give us time AND the necessary access to this large ifs directory

Now that I have explained the dilemma, does anyone know if these sql services will have the capability of not only listing the contents, but also being able to delete the contents with certain criteria (age etc.) of a directory?

Does anyone have something for me to look at/read?


Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of John Yeung
Sent: Thursday, January 21, 2016 5:02 PM
To: Midrange Systems Technical Discussion
Subject: List IFS files in a folder using SQL (was: Those new SQL things on IBM i)

On Thu, Jan 21, 2016 at 3:09 PM, Jeff Crosby <jlcrosby@xxxxxxxxxxxxxxxx> wrote:
I have a project coming up in a month or so where I will want a list
of files in an IFS folder. I'm hoping I can get that file list this way.

I suppose it would be nice. I love the idea of exposing more things via SQL (particularly when the easiest-to-use option thus far is a system API), and it looks like IBM is on that path.

But while you wait for IFS handling to show up in the official DB2 for i views and services (I'm guessing it will take longer than "a month or so" for this to happen), you can do it yourself by wrapping up the appropriate non-SQL code in UDFs or stored procedures.

If you don't want to wait, and you don't want to build your own UDFs/SPs, you could stick solely to SQL by relying on QSYS2.QCMDEXC to execute arbitrary CL commands (including the QSH command, to execute arbitrary Qshell commands like ls with the > redirection operator).
You may also have to use QCMDEXC to do CPYFRMSTMF or CPYFRMIMPF.

It's the good ol' dump-and-read technique. Byzantine, especially in this from-SQL incarnation, with probably tons of extra single-quotes to keep track of, but doable.

John Y.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
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.