42.7.3 操作系SQLの場合(DELETE文,INSERT文およびUPDATE文)
DELETE文,INSERT文およびUPDATE文を実行した場合,次に示す形式で操作行数が表示されます。操作行数がオーバフローした場合は,アスタリスク(*)が3つ表示されます。
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.
KFAA96415-Iメッセージは,#SET EXECTIME REPORTでON(SQL文の実行時間を出力する)を指定した場合に出力されます。