topic Re: Is it possible ? in Application Development and Automation Discussions

Is it possible ?

Former Member — Thu, 22 Nov 2007 12:08:39 GMT

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

Re: Is it possible ?

Former Member — Thu, 22 Nov 2007 12:22:27 GMT

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

Re: Is it possible ?

Former Member — Mon, 26 Nov 2007 11:36:22 GMT

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

Re: Is it possible ?

Former Member — Mon, 26 Nov 2007 12:05:26 GMT

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.

Re: Is it possible ?

Former Member — Mon, 26 Nov 2007 12:13:21 GMT

But how to make a connection to the sql database

Re: Is it possible ?

Former Member — Mon, 26 Nov 2007 12:18:32 GMT

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)

Re: Is it possible ?

Former Member — Mon, 26 Nov 2007 12:22:37 GMT

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

Re: Is it possible ?

Former Member — Mon, 26 Nov 2007 12:24:34 GMT

is the underlying database common for both the systems?

Re: Is it possible ?

Former Member — Mon, 26 Nov 2007 12:29:20 GMT

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