HP 3000 Manuals HP 3000 Manuals
ENABLE AUDIT LOGGING
The ENABLE AUDIT LOGGING statement restarts audit logging for the
DBEnvironment after a DISABLE AUDIT LOGGING has been performed.
Scope
ISQL or Application Programs
SQL Syntax
ENABLE AUDIT LOGGING
Description
* This statement reenables audit logging in the current session
only.
* This statement and DISABLE AUDIT LOGGING are not used to turn on
and off the AUDIT LOG option specified for processing of all
sessions in the DBEnvironment. These statements affect your
current session only. (The statements that affect all processing
in the DBEnvironment are the START DBE NEW and START DBE NEWLOG
statements.)
* This statement is not affected by transaction management
statements and remains in effect until a DISABLE AUDIT LOGGING
statement is issued.
Authorization
This statement requires DBA authority.
Example
Perform an initial load of a table without audit logging.
DISABLE AUDIT LOGGING;
LOAD FROM INTERNAL PartsData TO PurchDB.Parts;
COMMIT WORK;
Reenable audit logging and continue.
ENABLE AUDIT LOGGING;