Skip to content

ABAP Keyword Documentation →  ABAP - Reference →  Processing External Data →  ABAP - Database Accesses →  Open SQL →  Open SQL - Read Accesses →  SELECT →  SELECT - source 

SELECT - source, connection

Other versions: 7.31 | 7.40 | 7.54

Addition

... CONNECTION {con|(con_syntax)}

Effect

The Open SQL command is not executed on the standard database but on the secondary database connection specified.The database connection can be specified statically with con or dynamically as the content of con_syntax, where the field con_syntax must be of type c or string. The database connection must be specified with a name that is in column CON_NAME in table DBCON.

The addition CONNECTION must be specified immediately after the name of the database table or after the addition CLIENT SPECIFIED.


Notes

  • To allow the Open SQL command to be run for the secondary database connection, the table definitions in the connection must be the same as those in the standard database.
  • Creating and changing entries in the database table DBCON must only be carried out using the DBA Cockpit tool.