Is it possible ?

[Former Member]

Is it possible to update an sql table from an RFC without any interface in between?

[Former Member]

Hi Geet,

I assume that when u say "from an RFC" u mean that inside u write abap. If so, u can run native sql on outside DB from abap.

It will look something like this:

EXEC SQL.

insert into DatabaseTable.tab1

(

field1,

field2,

field3,

.......

)

VALUES

(

:value1,

:value2,

:value3,

..........

)

ENDEXEC.

Good luck

Pls reward points if helpful

Igal

[Former Member]

I dint understand what do u mean by tab1 in database table.tab1.Plz reply

[Former Member]

if you are running an RFC to change the Database contents that means you need some interface between theese two systems.

via RFC you can change the database contents.

[Former Member]

But how to make a connection to the sql database

[Former Member]

with RFC you make connection to the server...

and the directly you can code to access the SQL database.. as you do with the local database...

(i.e. via select query)

[Former Member]

The problem is i dont want to use any interface in betwenn can i update an sql table just by writing ABAP code

[Former Member]

is the underlying database common for both the systems?

[Former Member]

No, i want to update my sql database from my SAP database and vice versa