cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Open Sql and Native Sql

Former Member
0 Likes
416

Hi all,

Can anyone explain me the diference between open sql and native sql ? The select statements we use belongs to which category ?

Regards,

Varun.

View Entire Topic
Former Member
0 Likes

Open SQL is a set of ABAP/4 commands which perform operations on

database tables. The results of these operations and associated error

messages are independent of the database system used. Open SQL thus

offers you unified SQL syntax and semantics for different database

systems (see Portability). An ABAP/4 program which uses these commands

can be run on database systems supported by SAP without modification.

***************************

Native SQL allows you to perform operations on databases over and above

those in the Open SQL command set. In contrast to Open SQL, Native SQL

supports not only operations on the local database active in the R/3

System, but also on any external databases.