OPEN SQL & NATIVE SQL

原创于 2009-04-02 16:13:00 发布 · 834 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sql #database #primitive #dictionary #each

ABAP 专栏收录该内容

34 篇文章

订阅专栏

本文介绍了OpenSQL和NativeSQL两种SQL使用方式的区别。OpenSQL允许开发者通过供应商独立的接口直接控制SQL语句，实现跨数据库的一致性操作。而NativeSQL则允许使用特定于数据库的SQL语句，适用于那些不在ABAP字典中管理的数据库表。

Open SQL

Open SQL allows developers to control SQL statements directly. Open SQL encapsulates the semantics for statement execution, parameter binding and results fetching provided by each database vendor in a vendor- independent interface. The operations performed with Open SQL translate directly to the primitive operations provided by each database, yet the API is consistent across all vendors.

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.

------------------

详细介绍:

What is difference between Open SQL & Native SQL?

链接：http://www.saptechies.com/what-is-difference-between-open-sql-native-sql/