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

Different types of locks?

607


What are the difference between call screen and leave screen?

581


Did you create any joins?

523


What is the use of at new statement ?

1336


What is the difference between function group and function module?

497






What are the 3 methods that we use in sequence in a batch input session method? : abap bdc

547


What is lock mechanism? How do we create lock objects in abap?

620


What are the domains and data elements?

883


Explain what is the purpose of sap script?

552


Difference between sy-tabix and sy-index? Where it is used?

500


What is the difference between free and refresh?

569


What is PS structure

1610


How to Raise a Particular Ticket in Realtime ?

1606


What is filter dependent BADI?

906


Where the payroll results are stored

1783