Did you know that when you execute UPDATE, DELETE or INSERT statements in Db2 Administration Tool, you can display the number of rows that were affected?
After you execute one of these SQL statements, a message confirms that the statement was executed. While this confirmation message is displayed, you can press PF1 to also display informational message ADB260I, which reports the number of rows affected.
- Use option 2.1 or 2.2 to execute UPDATE, INSERT, or DELETE statements, such as:
INSERT INTO TS5772.DISCOUNT
After the statement is executed, a confirmation message is displayed:
ADB22 min -------------------- Execute SQL Statements ------------------- 16:30
INSERT stmt executed
1 - Edit/run SQL statements DB2 System: DC1A
2 - Run or Explain SQL statements DB2 SQL ID: TS5772
3 - Build SQL SELECT, INSERT, UPDATE or DELETE prototype
4 - Create/drop/label/comment on objects
5 - Grant/revoke privileges on objects
- Press PF1 to see the number of affected rows displayed at the bottom of the screen:
ADB260I 1 row(s) affected by the INSERT statement