What is the difference between OpenSQL and Native Sql?
Answers were Sorted based on User's Feedback
Answer / akhil
OPEN SQL
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 the ABAP/4 program.
Native SQL
Native SQL allows you to use database-specific SQL
statements in an ABAP program. This means that you can use
database tables that are not administered by the ABAP
Dictionary, and therefore integrate data that is not part
of the R/3 System.
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / gandhi
Open SQL:
Open sql will access the database without any
interface. which means no need to worry about the Database
manufacturer.
Native SQL:.
Native Sql are specific to database (ie
Oracle, SQL, Sybase, posgres, Access, DB2.)
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / cutie
Well Open SQL is teh DATA MANIPULATION LANG(DML) tht is it
allows only to access teh data,insert,delete append teh
tables.
THE native SQL is the Data Definitaion LAnguage it allows u
to create tables.
Is This Answer Correct ? | 2 Yes | 0 No |
What type of user exits have you written?
3 Answers Deloitte, Kingfisher,
what are the events of table maintenance generator?
what is the use of help view?how can we create search help for a field?in how many ways we can give search help?
Name the special commands of list?
ALV's?
1) If the scripts are client dependent, what above driver program ? (client dependent / independent) 2. I have two pages, In one page I want address, Header, Main & footer. In the second page I want only Main. How to do it? 3) Will 50,000 records be uploaded directly into APP's Server? 4) What is the button to change the variant in ALV ? 5) If your project is support project ? when is your implementation has completed ? 6)In start of selection, if we perform validation, what happens ? 7)How to join 3 tallies & looping. We have developed a program in a client say (200- client) and 210 has test data. No developing rights. How to test data? 8)How to transfer data which is coming from are report as output to another report 9)How to create standard text and how do u transfer it ? 10)What are the views when we are creating Material ?
which command is used to flushes the database buffer?
Whom you report if you face difficulty in understanding the business process given in Functional Spec.
What is the function of the transport system and workbench organizer?
what is 3 tire architecture and how does SAP utilizes this architecture. and how do netweaver came into picture?
Can i create a Table without a Data Element ? How ?
i am learning abap and finding very diffculty in understanding the message control technique especially in sending IDOCS? what are the steps in message control ?