Activity logged for databases with transaction logging
If a database uses transaction logging, the following SQL statements
generate one or more log records. If these statements are rolled back,
the rollback also generates log records.
- DELETE
- FLUSH
- INSERT
- LOAD
- MERGE
- PUT
- SELECT INTO TEMP
- UNLOAD
- UPDATE
The following SQL statements generate logs in special situations.
| SQL statement | Log record that the statement generates |
|---|---|
| BEGIN WORK | Returns an error unless the database uses transaction logging. A log record is produced if the transaction does some other logging work. |
| COMMIT WORK | Returns an error unless the database uses transaction logging. A log record is produced if the transaction does some other logging work. |
| ROLLBACK WORK | Returns an error unless the database uses transaction logging. A log record is produced if the transaction does some other logging work. |
| EXECUTE | Whether this statement generates a log record depends on the command being run. |
| EXECUTE FUNCTION | Whether this statement generates a log record depends on the function being executed. |
| EXECUTE IMMEDIATE | Whether this statement generates a log record depends on the command being run. |
| EXECUTE PROCEDURE | Whether this statement generates a log record depends on the procedure being executed. |