What is the difference between open sql & native sql ?
Answers were Sorted based on User's Feedback
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|
How to create Reports with Radio Buttons, which gives sales information, Delivery information and Billing information. plz mention the detail coding Tahnks, Rahul
how to debug a screen without using /h,break-point,debuging,stop.
i have a doubt ,what is the difference between the workarea and headerline . plz tell me .
can any one tell me the types of smartforms
BDC CALL TRANSACTION carry on synchronous processing and update the database both synchronously and asynchronously,where session method carry on asynchoronous processing and update the database synchrousnously.I want to know the meaning of synchronous and asynchronous processing and also the meaning of synchronous and asynchronous database update.
12) How to add Text Modules in SMARTFORMS?
when do you need to create an internal table with header line ? and with out a header line?
1. Driver prog & executive prog both r same ? 2. what is difference between At selection screen & At selection out put ? 3 . what is node used in smart form ?
in mm and sd,in which table plant and storage location are there?
in real time with the help of scripts what we can do?
SAP Date Format?
1.how to developed inreractive report 2.how to developed classicall report.