Update External MS SQL Table from ABAP

[anuradha_wijesinghe]

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.

[anuradha_wijesinghe]

BUMP........

[VolkerBarth]

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

[Matt_Fraser]

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.

Cheers,
Matt