Skip to Content

Update External MS SQL Table from ABAP

Nov 16, 2016 at 04:38 AM


avatar image
Former Member

Hi Experts,

I'm trying to pass data from ABAP to SQL table of external DataBase. Regarding this, i have bellow concerns.

1. First I want to know, is it possible.

2. What are the methods that can be connect QSL DB.

3. How can I connect and, how to write the UPDATE Query from ABAP program to external SQL DB.

4. Any example to update SQL DB table from ABAP.

Can anyone please answer for above.

10 |10000 characters needed characters left characters exceeded
Former Member



Note, the tag "SAP SQL Anywhere" is for that according DBMS, not for general SQL questions. Does that question relate to the SQL Anywhere product?

Otherwise, I would suggest to use a different tag...

(And sorry, I don't have the answer.)

* Please Login or Register to Answer, Follow or Comment.

1 Answer

Matt Fraser
Nov 16, 2016 at 10:11 PM

Yes, it is possible. Research the documentation for DBCO and you'll find out what you need to know.

Otherwise, please don't ask for folks to complete the solution for you. You've practically asked for us to write the solution. If you look up the documentation on DBCO, you should be able to find everything you need to put this together.

Also, it's not necessary to 'bump' your question when it has only been out there for an hour. The folks who answer questions in this forum are, for the most part, volunteers with their own day jobs, so it is not reasonable to expect 'immediate' help. That's what you pay expensive maintenance to SAP for (although they would have classified this as 'consulting' and not 'maintenance').

As an aside, I removed the 'SQL Anywhere' tag, as it was irrelevant, as Volker mentioned.


10 |10000 characters needed characters left characters exceeded