RESET
MPE documents | |
 Complete PDF | |
| Table of Contents | |
| Index | |
| E0300 Edition 9 ♥ | |
| E0399 Edition 8 | |
| E0897 Edition 7 |
Scope
ISQL or Application Program
SQL Syntax
RESET {SYSTEM.ACCOUNT [FOR USER {*
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
|
RENAME TABLE |
RETURN |