×
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.
Get the list from SQL and pass the list to a shell script or Python program.
Or do a find in the bash shell into a Db2 table and do a join of some sort in SQL with you control file.
________________________________
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of K Crawford <kscx3ksc@xxxxxxxxx>
Sent: Thursday, September 5, 2024 9:16 AM
To: MIDRANGE-L@xxxxxxxxxxxxxxxxxx <MIDRANGE-L@xxxxxxxxxxxxxxxxxx>
Subject: IFS_OBJECT_STATISTICS equivalent over mounted drive?
CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
I am trying to verify that folder names in a control file do exist on the
IFS/mounted drive.
I can use this SQL, and it appears to work over an IFS drive.
SELECT ftpdir, c.*
FROM myLibrary.myCtrlFile c
WHERE *UPPER*(ftpdir) NOT IN
(SELECT *UPPER*(*SUBSTR*(PATH_NAME, *16*, *15*))
FROM TABLE (QSYS2.IFS_OBJECT_STATISTICS('/home/myFolder/', 'YES'
, '*ALLDIR'))
)
But my directory is a mounted drive. IFS_OBJECT_STATISTICS will not work
over mounted drives.
Do I have any other options?
As an Amazon Associate we earn from qualifying purchases.
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.
midrange.com
