topic Re: Difference >< Open Sql and Native SQL in Application Development and Automation Discussions

Difference >< Open Sql and Native SQL

Former Member — Thu, 04 Oct 2007 17:44:11 GMT

What is the Difference >< OPEN SQL and NATIVE SQL ?

Re: Difference >< Open Sql and Native SQL

Former Member — Thu, 04 Oct 2007 17:48:34 GMT

The main difference is that open SQL is transportable between SAP systems running different databases. Native SQL is particular to the database being used.

As a result open SQL doesn't support all the syntaxes of native SQL.

rob

Re: Difference >< Open Sql and Native SQL

Former Member — Thu, 04 Oct 2007 17:49:12 GMT

Hi Avi,

Open SQL - ABAP specific SQL

Native SQL - DB specific 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.

Reward if helpful.

Regards,

Harini.S

Re: Difference >< Open Sql and Native SQL

Former Member — Thu, 04 Oct 2007 17:50:02 GMT

Hi Avi,

There is an interface between our R/3 system and Database.

Using this interface. You can write open SQL statements to accsess Database. Here we don't bother whether it is Oracle, Informix etc. So the statement syntax will not be dependent on Database underlying.

In Native Sql we don't access thru Interface.Directly we access Database.So we need to Write the statements in the correct syntax. i.e Database dependent.This is faster but if you use this there will be some inconsistency. So always better use Open SQL

Regds,

Mukesh Kumar