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
How can we set the tablespaces and extent sizes ?
How can you distinguish between different kinds of parameters?
what are the problem we face during development( if we say v are in support(development)? what are the critical problems araises during LSMW updation and Smart form layout development for involce and po? very very important questions now a days commonly asking..plz plz reply me
How to maintain lists?
Can we control the sequence in which multiple implementations of a multiple use BADI are called? If yes, how?
What are dml commands in abap?
what is user specific parameter?
What are the differences between macro and subroutine?
What are the different attributes that can be assigned to a variant?
Explain pai and pbo.
How do you Export a session ?
Explain lsmw?
What is difference between dependent and independent data?
If I want to execute a program only in background not in foreground is there any option for this? : abap bdc
Explain the difference between a dialog program and a report?