Re: IFS_OBJECT_STATISTICS equivalent over mounted drive?

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

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.