Ansicht
Dokumentation

ABAPSELECT_ADDITIONS - SELECT ADDITIONS

ABAPSELECT_ADDITIONS - SELECT ADDITIONS

BAL Application Log Documentation   ABAP Short Reference  
This documentation is copyright by SAP AG.
SAP E-Book

SELECT, abap_options

Short Reference



... $[BYPASSING BUFFER$]
    $[CONNECTION con$|(con_syntax)$] ...

Additions

1.... BYPASSING BUFFER

2.... CONNECTION con$|(con_syntax)

Effect

These ABAP-specific additions of a main query of a standalone SELECT statement or WITH statement specify whether table buffering is bypassed, and define the database connection.

If the INTO clause is specified as last clause of the SELECT statement, the additions must be after the INTO clause. Otherwise, they can also be after the SELECT clause or after the FROM clause.

Addition 1

... BYPASSING BUFFER

Effect

This addition causes the SELECT statement to bypass the table buffering of buffered DDIC database tables or DDIC views. Any buffers on the current are not accessed and the database is accessed directly instead.

Notes

  • The addition BYPASSING BUFFER can be used if it is vital that the current data is accessed for a buffered table instead of the buffer.
  • The addition BYPASSING BUFFER can be specified for unbuffered DDIC database tables or views in which case it describes the regular behavior.
  • The addition BYPASSING BUFFER does not ensure that data in an internal table is transported to the database when reads are performed on the table using FROM ... @itab.

Example

Access to the most current data of the fully buffered DDIC database table SPFLI.

Addition 2

... 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.
  • The addition CONNECTION cannot be used together with the addition WITH HOLD of the statement OPEN CURSOR.

Example

Reading of data using a service connection to the standard database.






CL_GUI_FRONTEND_SERVICES - Frontend Services   General Material Data  
This documentation is copyright by SAP AG.

Length: 4875 Date: 20240329 Time: 140303     sap01-206 ( 77 ms )