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.

asked 30 Aug '16, 06:05

Volker%20Barth's gravatar image

Volker Barth
29.5k291441646
accept rate: 32%

edited 30 Aug '16, 06:14


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?

permanent link

answered 30 Aug '16, 06:56

Breck%20Carter's gravatar image

Breck Carter
26.8k419580826
accept rate: 20%

converted 30 Aug '16, 07:53

Volker%20Barth's gravatar image

Volker Barth
29.5k291441646

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:)

(30 Aug '16, 07:53) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×21
×20

question asked: 30 Aug '16, 06:05

question was seen: 148 times

last updated: 30 Aug '16, 07:53