What is OPEN SQL vs NATIVE SQL?
By on Apr 2, 2007 in SAP-ABAP Interview Questions
Open SQL – These statements are a subset of standard SQL. It consists of DML command (Select, Insert, Update, Delete). It can simplify and speed up database access. Buffering is partly stored in the working memory and shared memory. Data in buffer is not always up-to-date.
Native SQL – They are loosely integrated into ABAP. It [...]
1 Comment(s)
By aman on Mar 9, 2008 | Reply
Open sql is a subset of Ansi SQL or Native Sql and is used in Abap/4 as the standard programming language. Open Sql is platform independent and database independent where as Native Sql is not.Some of the important features of Open Sql are automatic client handling and buffering . Open Sql is a DML(Data Manipulation language) where as Native sql is both DDL(data definition language and DML.
We can also use Native Sql is Abap but it has to be enclosed in statements EXEC stmt. and
EndExec. Syntax errors cannot be checked and also comment lines cannot be introduced. It bypasses Database Interface where as Open Sql does not.