Hitachi

Hitachi Advanced Database Command Reference


38.7.4 Data manipulation SQL statements (PURGE CHUNK and TRUNCATE TABLE statements)

When the PURGE CHUNK or TRUNCATE TABLE statement is executed, a completion message is displayed in the following format after execution of the SQL statement:

COMMAND ?     +----2----+----3----+----4----+----5----+----6----+----7----+
PURGE CHUNK "T1" WHERE CHUNKID=1;
KFAA96403-I SQL processing completed.
KFAA96415-I SQL processing time (Execute) : 0.901023 sec.
 
COMMAND ?     +----2----+----3----+----4----+----5----+----6----+----7----+
TRUNCATE TABLE "T1";
KFAA96403-I SQL processing completed.
KFAA96415-I SQL processing time (Execute) : 0.000865 sec.

The KFAA96415-I message is issued when ON (output SQL statement execution time) is specified in #SET EXECTIME REPORT.