What is the difference between open sql & native sql ?

Answer Posted / sugandha verma

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.

Is This Answer Correct ?    4 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain how is batch input process different from processing on line?

739


how to genernate 21 sencondary index

7599


How do you write a function module in sap?

763


How to pass data from list to report?

739


What is the process to enhance the Infotype

3081






What are the different buffering methods?

751


How many default tab strips are there? How to insert more tabs in it?

776


Explain the function module in bdc?

776


Can we use on change of between select and endselect?

771


Explain about interactive report?

777


What is a table pool? : abap data dictionary

793


A function module can be called from a transaction screen outside an abap/4 program. State true or false. : abap modularization

733


What are the modes in lock objects? : sap abap data dictionary

751


What are the different types of the variable in the sap abap?

772


Can anyone done BDC/LSMW/BAPI for F-02 and F-04.If yes let me know the processs

2183