Re: How to check if exist in IFS (QTNC) a file

Gio,
There are these things called "SQL services". These obsolete many of the
APIs we often used in dealing with operating system stuff, like listing
file information.
However, the one SQL Service that I thought would be great for this project
does not support QNTC.

For an overview listing of these SQL Services, what level of OS (and/or
PTF) they require, etc you can check out:
https://www.ibm.com/support/pages/ibm-i-services-sql
For a detailed explanation of how to use each of them you can look at:
https://www.ibm.com/docs/en/i/7.6.0?topic=optimization-i-services

On Fri, May 8, 2026 at 9:44 AM gio.cot via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

Hi thanks all
With extproc('access') it works (also for windows server mapped Via
QTNC) , but it needs file name complete , i would need to use instead a
file name generic, olny partial name ..
For the Stefan and Rob messages, sorry but in don't well understand what
do you mean .. if you can better explain i would be gratefull

Thanks



Shouldn't the C-style IFS API also work in/on /QNTC? Has someone tried it
with access()?

Wasn't "transparency" the root-idea behind QNTC?

I don't have a QNTC counterpart here, so I can't test it myself.

Regards,
Daniel

Am 08.05.2026 um 14:47 schrieb stefan@xxxxxxxxxx:

You can use the stat64 ( for larger files ) or stat ( for files up to

around 2Gb) in the following file systems:

* "Root" (/)
* QOpenSys
* User-defined
* QNTC
* QSYS.LIB
* Independent ASP QSYS.LIB
* QOPT
* Network File System
* QFileSvr.400



Best regards



Stefan



--

No trees were killed in the sending of this message, but a large number

of electrons were terribly upset.

Stefan Tageson

+46 732 369934

stefan@xxxxxxxxxx<mailto:stefan@xxxxxxxxxx>



________________________________
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of
Rob Berendt <robertowenberendt@xxxxxxxxx>
Sent: Friday, May 8, 2026 14:20
To: Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: How to check if exist in IFS (QTNC) a file

Too bad:

IFS_OBJECT_STATISTICS table function
No rows are returned for remote file system objects. This means that
for the QNTC file system, only a row for /QNTC is returned. For the
Network File System (NFS) and QFileSvr.400 file systems, no rows are

returned.

On Fri, May 8, 2026 at 6:31 AM gio.cot via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

Hi all



I would need to check in a windows server (mapped via QTNC), if exist
a file with partial name;

example: if i run "DSPLNK
OBJ('/qntc/zz-yy-appxx/XT/DOCS/TX/ORDERS/HIST/myfile_26_90501*') , i
can see that in the folder exist a file named

"myfile_26_90501_11052026.txt"

can i do with clp or rpg run a command to check existance passing the
file partial name ?

usually i use extproc('access') File_Exists = access(pathptr:F_OK)

Thanks in advance

Gio

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

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


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