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. |
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?
Not in my case.
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:)
(30 Aug '16, 07:53)
Volker Barth
|