What is the difference between open sql & native sql ?
Answer Posted / nasreen
Open SQL allows you to access all database tables known to
the SAP system, regardless of the database manufacturer.
Sometimes, however, we may want to use database-specific
SQL statements called Native SQL in your ABAP/4 program. To
avoid incompatibilities between different database tables
and also to make ABAP/4 programs independent of the
database system in use, SAP has created a set of separate
SQL statements called Open SQL.
| Is This Answer Correct ? | 14 Yes | 1 No |
Post New Answer View All Answers
Why do we use FOR ALL ENTRIES and what is the pre-requisite
Static and instance variable and method with live example. Why and when to use
Which function module reads the data for particular infotype ? : abap hr
What are the screen elements.
In which cluster time results are stored? : abap hr
How can we upload a text file having delimiters in to legacy system?
What is the difference between commit-work and rollback-work tasks?
Give few names of pooled tables in sap ?
What are secondary indexes. How can we know which index is being used in a select query?
Why do we use Abstract classes give an example from your project?
Normally how many and what files get created when a transaction program is written? what is the XXXXXTOP program?
What are different abap/4 editors?
Explain what are the various types of selection screen event?
When to use logical database?
What is the difference between table and template?