HPlogo ALLBASE/SQL Reference Manual: HP 9000 Computer Systems > Chapter 11 SQL Statements E - R

ENABLE AUDIT LOGGING

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

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;
Feedback to webmaster