HP 3000 Manuals

ALLBASE/SQL Reference Manual

RESET 

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

Scope 

ISQL or Application Program

SQL Syntax 

      {SYSTEM.ACCOUNT [FOR USER {*        }]}
RESET {               [         {DBEUserID}]}
      {                                     }
      {SYSTEM.COUNTER                       }

Parameters 

SYSTEM.ACCOUNT          is specified to reset accounting data for one
                        user's DBE session or for all active sessions.

*                       specifies all active sessions.  This is the
                        default if the FOR USER clause is omitted.

DBEUserID               identifies the user of a specific DBE session.

SYSTEM.COUNTER          is specified 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

MPE/iX 5.5 Documentation