ALLBASE/SQL Reference Manual (36216-90216)

Chapter 10 389

SQL Statements A - D

DISABLE AUDIT LOGGING

The DISABLE AUDIT LOGGING statement stops audit logging for the DBEnvironment

session. It allows you to avoid creating audit log records for SQL statements while hard

resynchronization is performed.

Scope

ISQL or Application Programs

SQL Syntax

DISABLE AUDIT LOGGING

Description

• This statement disables audit logging in the current session only. It suspends the

generation of audit log records for any statements issued during the session.

• This statement and ENABLE AUDIT LOGGING are

not

used to turn on and off the

AUDIT LOG option speciﬁed 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 an ENABLE AUDIT LOGGING statement is issued, or until the end of the

current session.

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;