38.7.3 Data manipulation SQL statements (DELETE statement, INSERT statement, and UPDATE statement)
If the DELETE, INSERT, or UPDATE statement is executed, the number of manipulated rows is displayed in the format shown below. If the number of manipulated rows results in an overflow, three asterisks (***) are displayed.
COMMAND ? +----2----+----3----+----4----+----5----+----6----+----7----+
DELETE FROM "T1" WHERE "C1"=0;
KFAA96404-I 1 rows were deleted.
KFAA96415-I SQL processing time (Execute) : 40.011020 sec.
COMMAND ? +----2----+----3----+----4----+----5----+----6----+----7----+
INSERT INTO "T1"("C1","C2") VALUES(+1520.34,'abc');
KFAA96404-I 1 rows were inserted.
KFAA96415-I SQL processing time (Execute) : 0.501823 sec.
COMMAND ? +----2----+----3----+----4----+----5----+----6----+----7----+
UPDATE "T1" SET "C1"=0 WHERE "C1"<0;
KFAA96404-I 2 rows were updated.
KFAA96415-I SQL processing time (Execute) : 120.991024 sec.
The KFAA96415-I message is issued when ON (output SQL statement execution time) is specified in #SET EXECTIME REPORT.