Hi, as stated in the title, Is there any similar command in ADS with mySQL LOAD command? I want to import text file directly into table (create new if have to) without using arc. Thanks in advance for the help.

asked 22 May '13, 21:52

Tanuwijaya's gravatar image

Tanuwijaya
1369916
accept rate: 0%


ADS doesn't have a built in command to load from external files. The only way ADS provides is to use Data Architect (so it's client side).
BUT....
ADS allows to write and register Extended Procedures. If you require the functionality on a regular base, you can write it by yourself.

link

answered 23 May '13, 00:11

Joachim%20Duerr's gravatar image

Joachim Duerr
8.7k1031133
accept rate: 18%

Thanks for the answer and inspiration to create a storeprocedure about it.

(24 May '13, 05:09) Tanuwijaya

to make the concept more clear: here you can find a blog post dealing with it.

link

answered 24 May '13, 04:37

Joachim%20Duerr's gravatar image

Joachim Duerr
8.7k1031133
accept rate: 18%

Your answer to the original question.
If responding to a request for additional information, please edit the question or use the comment functionality.
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

Tags:

×325

Asked: 22 May '13, 21:52

Seen: 1,521 times

Last updated: 24 May '13, 05:09

Advantage Developer Zone Contact Us Privacy Policy Copyright Info


Powered by Advantage Database Server and OSQA
Disclaimer: Opinions expressed here are those of the poster and do not necessarily reflect the views of the company.