Update non sap database using abap code

[Former Member]

Dear all,

I would like to update non sap database using abap code. Does this can be done and any sample programs? Thanks.

Regards,

ain

[Former Member]

Hi

Check the Transaction

<b>OIDV</b> -to update MS acess tables from SAP data

see the program

<b>RIACCESS</b>

Reward points if useful

Regards

Anji

[Former Member]

Hi,

we can update the ztable by using

modify or update statements

like modify ztable from table itab.

or update ztable from table itab.

reward points if helpful

thanks

venkatesh

[Former Member]

Hi,

Thanks for the info. But actually my requirement is there are Java programs that will call abap program or RFC program and these programs need to update to Oracle database ( not sap database ). I'm not sure this can be done. Anyone can help me? If can ... kindly provide me sample program. Thanks.

[alejandro_bindi]

Surely that can be done. You must use Native SQL in order to do this.

Beware though that the code you write for use with Oracle DB may stop working if tomorrow it gets migrated to another RDBMS, say SQL server for example.

The syntax is like this:

EXEC SQL [PERFORMING <form>].
  <Native SQL statement>
ENDEXEC.

Check this text from help:

<b>Native SQL

Open SQL allows you to access database tables declared in the ABAP Dictionary regardless of the database platform that you R/3 System is using. Native SQL allows you to use database-specific SQL statements in an ABAP program. This means that you can use database tables that are not administered by the ABAP Dictionary, and therefore integrate data that is not part of the R/3 System.

As a rule, an ABAP program containing database-specific SQL statements will not run under different database systems. If your program will be used on more than one database platform, only use Open SQL statements.

</b>

Please award points if this helps.

[Former Member]

Can you please advice how to update oracle database using Native SQL from SAP