ALLBASE/SQL Reference Manual (36216-90216)

Chapter 11 411

SQL Statements E - R

ENABLE AUDIT LOGGING

11 SQL Statements E - R

Chapter 10, 11 and 12 describe all the SQL statements in alphabetical order, giving

syntax, parameters, descriptions, authorization requirements, and examples for each

statement. Examples often consist of groups of statements so you can see how each

statement is related to other statements functionally.

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 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 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;