Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

wats d difference btwn open SQL and native SQL??

Former Member
0 Kudos
128

wats d difference btwn open SQL and native SQL??

can ny1 explain in detail...if possible wid examples??

regards

ziden.

1 ACCEPTED SOLUTION

ferry_lianto
Active Contributor
0 Kudos
84

Hi,

Open SQL allows you to access all database tables known to the SAP system, regardless of the database manufacturer. Sometimes, however, we may want to use database-specific SQL statements called Native SQL in your ABAP/4 program.

To avoid incompatibilities between different database tables and also to make ABAP/4 programs independent of the database system in use, SAP has created a set of separate SQL statements called Open SQL. Open SQL contains a subset of standard SQL statements as well as some enhancements which are specific to SAP.

A database interface translates SAP's Open SQL statements into SQL commands specific to the database in use. Native SQL statements access the database directly.

Regards,

Ferry Lianto

4 REPLIES 4

Former Member
0 Kudos
84

open sql is specific to abap.

native sql is the syntax of common SQL.

open sql internally converts into native sql and contact database server.

regds,

kiran

Former Member
0 Kudos
84

Hi,

ABAP Native SQL allows you to include database-specific SQL statements in an ABAP program. Most ABAP programs containing database-specific SQL statements do not run with different databases.

If different databases are involved, use Open SQL.

To execute ABAP Native SQL in an ABAP program, use the statement EXEC. Open SQL (Subset of standard SQL statements), allows you to access all database tables available in the R/3 System, regardless of the manufacturer.

To avoid conflicts between database tables and to keep ABAP programs independent from the database system used, SAP has generated its own set of SQL statements known as Open SQL.

Thanks,

Naren

Former Member
0 Kudos
84

Check <a href="http://help.sap.com/saphelp_47x200/helpdata/EN/fc/eb3b8b358411d1829f0000e829fbfe/frameset.htm">Native SQL</a>

Rob

ferry_lianto
Active Contributor
0 Kudos
85

Hi,

Open SQL allows you to access all database tables known to the SAP system, regardless of the database manufacturer. Sometimes, however, we may want to use database-specific SQL statements called Native SQL in your ABAP/4 program.

To avoid incompatibilities between different database tables and also to make ABAP/4 programs independent of the database system in use, SAP has created a set of separate SQL statements called Open SQL. Open SQL contains a subset of standard SQL statements as well as some enhancements which are specific to SAP.

A database interface translates SAP's Open SQL statements into SQL commands specific to the database in use. Native SQL statements access the database directly.

Regards,

Ferry Lianto