Is there a facility to list client-side files?

[VolkerBarth]

I'm using a bunch of client files to import data via LOAD TABLE ... USING CLIENT FILE with a v16.0.0.2270 database. It's a one-time task so I'm solving this via a simple SQL script.

As there are a bunch of these files in several directories (not directly accessible from the database server), I'd like to have a function/procedure to list those, such as v16's sp_list_directory() procedure or via a directory access server, and would then use that to repeat the import for each listed file.

But in my understanding those do only work with server-side files, not with client-related files.

So I'm quite sure the answer to my question is "No" - or have I overlooked a feature here?

---

If it's "No", well then I'll find a way to list them files locally and feed the script with the file pathes somehow, so that would surely be feasible.

[Breck_Carter · Accepted solution]

Are UNC paths or mapped network drives available?

How about dir /b /s >c:\\temp\\dir.txt to create a file for LOAD ... USING CLIENT FILE?

[VolkerBarth · Accepted solution]

Are UNC paths or mapped network drives available?

Not in my case.

How about dir /b /s >c:\\temp\\dir.txt to create a file for LOAD ... USING CLIENT FILE?

Wow, that's a really smart idea, particular as it does use the client-side access. Once again, I'm really glad I have asked here:)