What is the difference between open sql & native sql ?
Answers were Sorted based on User's Feedback
native sql : are not checked and converted they are sent
directly to the database system.allows to use database
specific sqql statements in an abap program.
Open sql: it will work on any r/3 system regardless of the
database system in use.
Is This Answer Correct ? | 24 Yes | 4 No |
Answer / 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 |
Answer / g.jayaprakash
open sql is not confined to any particular type of database
while a native sql is confined to a particular one.
Is This Answer Correct ? | 15 Yes | 4 No |
Answer / 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 |
What is collect statement?explain with example?
What is difference between check table and value table ?
Which is the event trigger last?
suppose you are using session method for 1000 records and there is error in 400 and 500 records.how many records will be updated to the database?
In real time how we get the tickets? whether it is through email or any thing else.
How to maintain the table control in BDC?
Can we define our own match code id's for sap matchcodes? : abap data dictionary
Explain what are the different functions used in sap script? What are the parameters used in each function?
delivery and data class.
WHAT IS DOCUMENTATION?WHY IT IS USED?
Q2.What is the special character is used to mask a single characher. 1. & 2. % 3.’_____ 4._____’
Did u inherit any standard sap programs? what are they? and for what purpose you have done it?