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
Double click function on the lists, identifying the line selected by the user on the list?
What is an internal table?
What is the step-by-step process to create a table in data dictionary? : abap data dictionary
What is buffering allowed but switched off?
What is the difference between abap and hr abap? : abap hr
Program lines for the radio button selection and unabling some input variables in section screen
What is the table buffer?
What is example class
What is your approach to find exit and BAdi?
What is the difference between pnp and pnpce? : abap hr
what are the important fields while preparing sales order,inquiry?
How you attach search help to data element? : sap abap data dictionary
Can any tell me ECC 5.0, ECC 6.0 Released year? and difference between them?
Explain the differences between se01, se09 and se10?
What is roll area?