ALLBASE/SQL Reference Manual (36216-90216)

486 Chapter11

SQL Statements E - R

RESET

The RESET statement resets ALLBASE/SQL accounting and statistical data.

Scope

ISQL or Application Program

SQL Syntax

RESET {SYSTEM.ACCOUNT [FOR USER {*

DBEUserID

}]

SYSTEM.COUNTER }

Parameters

SYSTEM.ACCOUNT is speciﬁed to reset accounting data for one user's DBE session or for

all active sessions.

* speciﬁes all active sessions. This is the default if the FOR USER clause is

omitted.

DBEUserID

identiﬁes the user of a speciﬁc DBE session.

SYSTEM.COUNTER is speciﬁed to reset ALLBASE/SQL statistical counters.

Description

• Refer to the ALLBASE/SQL Database Administration Guide for more information

about the SYSTEM.ACCOUNT and SYSTEM.COUNTER views.

Authorization

You must have DBA authority to use this statement.

Example

The I/O resource usage for NewUser's current database session is set to zero.

RESET SYSTEM.ACCOUNT FOR USER NewUser