... {dbtab|(dbtab_syntax)} [CLIENT SPECIFIED]
[CONNECTION {con|(con_syntax)}] ... .
1. ... dbtab
2. ... (dbtab_syntax)
1. ... CLIENT SPECIFIED
2. ... CONNECTION {con|(con_syntax)}
The entries in target determine, statically or dynamically, which
database table or which
view is accessed, and control client handling.
... dbtab
For dbtab, a database table defined in the ABAP Dictionary or a view defined in the ABAP Dictionary can be specified.
Only views that refer to a single database table, and whose maintenance status in the ABAP Dictionary permits change access can be specified.
... (dbtab_syntax)
Instead of static specification, a bracketed data object dbtab_syntax can be specified, which must contain the name of the database table or the view when the statement is executed. A character-type data object can be specified for the data object dbtab_syntax. The syntax in dbtab_syntax, as in the AAP Editor, is not case-sensitive.
Before release 6.10, it was only possible to specify a
flat
character-type data object for
dbtab_syntax, which had to contain the name of the database table or the view in capital letters.
... CLIENT SPECIFIED
This addition deactivates the automatic client handling of Open SQL. If the addition CLIENT SPECIFIED is used, the client identifier specified in source is taken into account. Without the addition CLIENT SPECIFIED, the ABAP runtime environment does not transfer the client identifier specified in source to the database system, but transfers the identifier of the current client instead.
As of release 6.10, the client identifer specified in source
remains unchanged during automatic client handling. Before release 6.10, it was overwritten with the current client identifier.
... CONNECTION {con|(con_syntax)}
This addition is for internal use only.
It cannot be used in application programs
The Open SQL command is not executed on the standard database but on the specified secondary database connection. The database connection can be specified statically with con or dynamically as the content of con_syntax, where the field con_syntax must belong to the 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.
If the Open SQL command is to be possible on a secondary database connection, the table definitions in the connection must be the same as those on the standard database.
If individual columns are changed using SET, the dynamic specification of the database table or the views in dbtab_syntax are possible only since Release 6.10.