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

Can a posting run be deleted? : sap abap hr

783


What are the names of the function modules that will be generated upon activation of a lock object?

748


ALV Report that will show the details of order like order no, order date, customer, product code & description, order quantity and value along with the details of dispatch of those orders like invoice no, invoice date, invoice quantity and pending order quantity. plz mention the detail coding Tahnks, Rahul

2396


Explain about the tables exists in a data dictionary and what are they? : abap data dictionary

835


How many types of data classes are there in sap?

769


Explain the use of table maintenance allowed?

726


What is occurs in internal table?

824


How we can retrieve data using secondary index. Explain with simple example?

872


Can we define our own match code id's for sap matchcodes? : abap data dictionary

780


Name the function module used to convert logical file names to physical file names in abap/4 programs?

820


what are the important fields while preparing sales order,inquiry?

2091


Interactive Report that list purchase order details of a vendor. When the user double clicks on material number it shows detail list with fields matkl, meins, brgew, ntgew, gewei.The selection screen consist of sales organisation, distribution channel and material number. plz mention the detail coding Tahnks, Rahul

3469


How can we declare a table control in the abap/4 program?

851


How do you connect to the remote server if you are working from the office for the client in remote place?

802


List the various components of the enterprise structure in systems, applications, and products (sap) in human capital management (him)? : sap abap hr

687