COMMIT, ROLLBACK CONNECTION
COMMIT|ROLLBACK CONNECTION con.
ROLLBACK command executed on the
secondary database connection specified using
con performs a database commit
or database rollback. Here,
con is the name of the database connection, as
specified in the table DBCON in the column CON_NAME. The
database connection can also be specified dynamically in the
form, where the
source_text field contains the name of the database connection.
source_text field must be of the type
The database commit has the following effects on the specified secondary database connection:
COMMIT CONNECTION and
ROLLBACK CONNECTION do not close the current
It should be noted that the statement
COMMIT CONNECTION DEFAULTperforms a pure database commit on the
DEFAULTconnection, unlike the statement
Entries in the DBCON database tables can only be created or changed using the DBA Cockpit tool.