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
Explain what is step-loop? Explain all the steps?
What are the advantages and disadvantages of using views in abap programming ?
What are the types of views? : sap abap data dictionary
How can we determine a vendor is Bloc/Unblock from the table LFA1?
Where do you create indexes in abap?
What are logical databases? : abap hr
Can a transparent table exist in data dictionary but not in the data base physically? : sap abap data dictionary
Explain the structure of a bdc sessions?
Static and instance variable and method with live example. Why and when to use
What are the basic objects of the data dictionary? : abap data dictionary
I just wanted to know that when I am recruiting somebody, I am generating his personal no also. Then I want to give him training also. Now I just want to create 2 scenarios to clear my doubts? : sap abap hr
Difference between stand alone CRM and back-end CRM
What is database utility?
What is the use of message command in a report? What are the different message types?
What is the different between template and a table?