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
What is difference between dependent and independent data?
How can we determine a vendor is Bloc/Unblock from the table LFA1?
What does an exec sql statement do in abap?
What are authorization objects and what statement is used to perform an authorization check in an abap program?
Explain read dataset in sap abap?
Write the bdc table structure? : abap bdc
Explain what is an rdbms?
Explain how do you move on to the next screen in interactive reporting?
Does every abap/4 have a modular structure? : abap modularization
Can you create an internal table dynamically?(at run time)
What is abap?
How many default tab strips are there? How to insert more tabs in it?
What are hashed tables?
Write an abap program for creation of customer enquiry using BAPI 'BAPI_INQUIRY_CREATEFROMDATA'.
What are the different abap/4 editors?