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


Please Help Members By Posting Answers For Below Questions

difference between Valuation type and valuation category?

1978


Explain the difference between free and refresh?

565


What is the syntax for call transaction? : abap bdc

575


How would you suppress the display of a parameter on the selection screen?

540


What are interactive reports?

610






What is tcode se16. For what is it used. Explain briefly?

519


What are the different abap editors? What is the used of different editors in abap?

549


Exception handling and how does it transfer from called method to calling method?

849


I need the coding for BDC program to upload Purchase orders of known vendor (ME21) in Material Management

1736


What is “call mode”?

554


What are the types of windows in sap script?

589


Can anyone done BDC/LSMW/BAPI for F-02 and F-04.If yes let me know the processs

1826


How to transfer the objects? Have to transferred any objects?

557


What is meant by payscale structure? How did you configure pay scale structure? : sap abap hr

511


What is abap work bench?

701