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 is the diff between database view and maintenance view?
I need some information regarding Vcentric Test pattern ? with questions.
0 Answers vCentric Technologies,
what is the difference between user-exit & BADIs?
If internal table used in for all entries in empty then what happens?
what is the standard program used to upload/download layout sets in scripts.
how to fill the select options from an internal table dynamically ie can i use the loop in the initialization
I am looking for Professionals with 4+ yrs in ABAP HR Module (atleast 2yrs).
What are the different types joins?
i want to see a material master data which is at client side.How can i view that?
Why do we declare a method of a class final? What can be the purpose? Give a scenario.
2)what will be the size of transparant table
what is the role of secondary index in performance?