Ansicht
Dokumentation

ABAPINSERT_UPDATE_MODIFY_CONN - INSERT UPDATE MODIFY CONN

CL_GUI_FRONTEND_SERVICES - Frontend Services   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by SAP AG.

INSERT, UPDATE, MODIFY, DELETE dbtab - connection

Syntax

... 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.
  

Example

Deletes all data in a database table using a service connection to the standard database.

DELETE FROM demo_expressions CONNECTION r/3*my_conn.

PERFORM Short Reference   General Material Data  
This documentation is copyright by SAP AG.

Length: 1891 Date: 20240423 Time: 072935     sap01-206 ( 48 ms )