I'm using a bunch of client files to import data via LOAD TABLE ... USING CLIENT FILE with a v220.127.116.110 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.