ABAP Keyword Documentation → ABAP - Reference → Processing External Data → ABAP - Database Accesses
Native SQL
The term Native SQL refers to all statements that can be passed statically to the Native SQL interface of the database interface.
Native SQL statements do not fall within the scope of ABAP and do not follow ABAP syntax. ABAP only contains statements to isolate program sections in which Native SQL statements can be listed. Native SQL mainly uses database-specific SQL statements that are passed unchanged from the Native SQL interface to a database system, and executed there. The full SQL language scope of the relevant database can be used and the addressed database tables do not have to be declared in ABAP Dictionary. There is also a small set of SAP-specific Native SQL statements, which are handled in a specific way by the Native SQL interface.
The following statements are used to embed Native SQL in ABAP programs:
EXEC SQL ... ENDEXEC
You can use the ADBC methods for dynamic access to the Native SQL interface.
Other versions: 7.31 | 7.40 | 7.54