What is the difference between open sql & native sql

[Former Member]

What is the difference between open sql & native sql

[Former Member]

Hi

Native SQL is used to make calls to the database. The database in SAP can be anything like Oracle, MSSQL, Informix or DB2. And hence it is not possible to make changes everywhere if the database changes.

Hence, Open SQL is used by the ABAP programmers to make calls while accessing a database and these open SQL statements are sent to an DB Interface which decodes the open SQL to native SQL depending on the Database used. Thus you wont need to make any changes even if the database changes.

Please do reward points for this.

Regards,

Suhas

[Former Member]

Open SQL is the SQL language used internally by the SAP application server. Native SQL is the language used directly by the DB. The application server translates the OpenSQL to native SQL when sending commands to the DB.

Hope that is helpful.

J. Haynes