11-22-2007 12:08 PM
Is it possible to update an sql table from an RFC without any interface in between?
11-22-2007 12:22 PM
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
11-22-2007 12:22 PM
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
11-26-2007 11:36 AM
I dint understand what do u mean by tab1 in database table.tab1.Plz reply
11-26-2007 12:05 PM
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.
11-26-2007 12:13 PM
11-26-2007 12:18 PM
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)
11-26-2007 12:22 PM
The problem is i dont want to use any interface in betwenn can i update an sql table just by writing ABAP code
11-26-2007 12:24 PM
11-26-2007 12:29 PM
No, i want to update my sql database from my SAP database and vice versa