Re: IFS_OBJECT_STATISTICS equivalent over mounted drive?

Jack, the SQL works over a native IFS drive but not a mounted drive.
Rob, I will look at the QMGTOOLS/CHKIFS a bit more. my first glance is yes
it works. It is creating a data area and putting 00 in it if the directory
did not exist and a 01 if it did. Trying to figure out how to use this.
My hope was using my ctrlFile come up with a list of all directories that
do not exist. With the CHKIFS using a data area not sure how to use that
with my SQL statement. I guess I will need to write a program that will
read the ctrlFile run the command CHKIFS look at the data area then decide
if it was found or not populating table. That is a bit more work than I
wanted to do. Lazy at heart.


On Fri, Sep 6, 2024 at 6:31 AM Rob Berendt <robertowenberendt@xxxxxxxxx>
wrote:

I have a mounted directory. This works
QMGTOOLS/CHKIFS IFSDIR('/GDWEB/tmp/sshd.pid')
There's no help on that command. I did a DSPJOBLOG to figure out how it
worked.

In case you're wondering:
Allow RTVCLSRC (CL module) . . . . . . . . . . : *NO


On Thu, Sep 5, 2024 at 11:16 AM K Crawford <kscx3ksc@xxxxxxxxx> wrote:

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?

--
Kerwin Crawford
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

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

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.