What is the difference between open sql & native sql ?

Answers were Sorted based on User's Feedback

Answer / manikandan

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

Post New Answer

More SAP ABAP Interview Questions

What are the select-option fields?

5 Answers  

What is the diff b/w load of program and Initailazatio Events? Which event triggers each time we exectute the program?

1 Answers   HCL, HP,

what client you are working?

3 Answers   Accenture,

three jobs are there if one fails wat happens?

1 Answers  

what is the need of set parameter-id in reports.

1 Answers   IBM,

how many subscreens we can create in a main screen?

1 Answers  

what is the difference b/w linear search and binary search? (how can these search)

15 Answers   IBM, HCL,

Is there Any Module in SAP for Internal Audit?

1 Answers  

what is the difference between user-exit & customer-exit?

3 Answers  

1.Which of the following is not an EXIT command? options: BACK, CANCEL, STOP, EXIT? 2.To write certain contents in sap script without skipping to the next page, which command is used? Options: ADDRESS...ENDADDRESS, PROTECT...ENDPROTECT, AT...ENDAT 3. When using a table control in module pool, which statement has to present in both PAI and PBO. options : FIELD, LOOP..ENDLOOP, CHAIN...ENDCHAIN 4. Lock objects are : options : FUNCTION MODULES, PROGRAMS, TABLES

4 Answers   Accenture,

In se11 -->Tech. settings --> Data class. If I save table as Mater data OR Transaction data, what effect will it has for 'Storage' in Database after activation. or In Database how it will store in both the cases.

0 Answers   Patni,

what is the difference between bdc and rfc ?

3 Answers