Activity Logged for Databases with Transaction Logging

Home | Previous Page | Next Page Logging and Log Administration > Logging > Logging of SQL Statements and Database Server Activity >

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
PUT
SELECT INTO TEMP

UNLOAD
UPDATE

The following SQL statements generate log records 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.
EXECUTE	Whether this statement generates a log record depends on the command being executed.
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 executed.
EXECUTE PROCEDURE	Whether this statement generates a log record depends on the procedure being executed.