topic Re: Update non sap database using abap code in Application Development and Automation Discussions

Update non sap database using abap code

Former Member — Tue, 05 Jun 2007 07:12:49 GMT

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

Re: Update non sap database using abap code

Former Member — Tue, 05 Jun 2007 07:15:34 GMT

Check the Transaction

OIDV -to update MS acess tables from SAP data

see the program

RIACCESS

Reward points if useful

Regards

Anji

Re: Update non sap database using abap code

Former Member — Tue, 05 Jun 2007 07:34:24 GMT

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

Re: Update non sap database using abap code

Former Member — Wed, 06 Jun 2007 00:36:53 GMT

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.

Re: Update non sap database using abap code

alejandro_bindi — Wed, 06 Jun 2007 04:54:33 GMT

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:

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.

Please award points if this helps.

Re: Update non sap database using abap code

Former Member — Thu, 13 Sep 2007 04:34:43 GMT

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