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
Different types of locks?
What are the difference between call screen and leave screen?
Did you create any joins?
What is the use of at new statement ?
What is the difference between function group and function module?
What are the 3 methods that we use in sequence in a batch input session method? : abap bdc
What is lock mechanism? How do we create lock objects in abap?
What are the domains and data elements?
Explain what is the purpose of sap script?
Difference between sy-tabix and sy-index? Where it is used?
What is the difference between free and refresh?
What is PS structure
How to Raise a Particular Ticket in Realtime ?
What is filter dependent BADI?
Where the payroll results are stored