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 are the types of search helps? : sap abap data dictionary
Overall how do you write transaction programs in SAP?
Suppose in the Report Program I want to pass data to another Report Program ..how will you do that one?
What are the two different ways of building a match code object? : abap data dictionary
What is an update type with reference to a match code id?
what comes in Timkein written test I hope some body can tell me at this id plz tell it before 9 pm 19 march
Give Some examples of reports generated in real time scenarion? Also give examples of standard reports in SAP used in real time?
What is the button to change the variant in ALV ?p
From excel to abap - is batch mode possible ? : abap bdc
What is personnel sub are
Can we create a database table through a report?
please give the remaining answers.