Skip to content

ABAP Keyword Documentation →  ABAP - Reference →  Processing External Data →  ABAP - Database Accesses 

ADBC - ABAP Database Connectivity

ADBC is an API for the Native SQL interface of the AS ABAP that is based on ABAP Objects.

The methods of ADBC make it possible to;

  • send database specific SQL commands to a database system and process the result
  • to establish and administer database connections.

While the statements of Native SQL offer exclusively static access to the Native SQL interface, ADBC makes an object orientated and dynamic access possible.

The ADBC classes all begin with the prefix CL_SQL_ or CX_SQL_ and are documented. The following paragraphs briefly introduce the most important classes.

Other versions: 7.31 | 7.40 | 7.54

Programming Guideline

Using Open SQL


Notes

  • Note ADBC can always be used when access to a database via the Native instead of the Open SQL interface is necessary and static access is not sufficient.

  • ADBC does not support automatic client handling. The client ID of a database table must be specified explicitly. Note that application programs should only use data from the current client. In Multitenancy systems, this is checked by the ABAP runtime environment.

Continue

CL_SQL_STATEMENT - Execution of SQL Statements

CL_SQL_STATEMENT - Prepared SQL Statements

CL_SQL_CONNECTION - Database Connections

CX_SQL_EXCEPTION - Exception Class

Examples of ADBC