regarding open sql

[Former Member]

what is diff between OPEN SQL & NATIVE SQL

[RichHeilman]

SQL is implemented difference depending on the database, this is native SQL, SAP wants to provide an abstraction from this, so that the developer does not have to worry about what DB is running underneath, he can just write the SQL statement and it will run on any machine regardless of DB. This is OPEN SQL. This is the SQL statements that you use in your ABAP programs.

You can use Native SQL in your programs as well, but you must know about the underlying DB.

http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb3969358411d1829f0000e829fbfe/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb3b8b358411d1829f0000e829fbfe/frameset.htm

Regards,

Rich Heilman

[Former Member]

Open SQL: Sub set of Native SQL commands.

[anversha_s]

hi,

<b>native and open sql</b>

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

rgds

anver

pls mark hlpful answers