Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
- 1 Answers
- 1185 Views
- I also Faced
- E-Mail Answers
Answer / Akash Sharma
To compute the total number of updated rows after an UPDATE statement in DB2, you can use the ROWCOUNT statement. However, it's important to note that this statement should be executed before any COMMIT or ROLLBACK.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to resolve deadlock issue
Explain the function of data manager.
How do you concatenate the firstname and lastname from emp table to give a complete name?
What are the various locks available?
Why select is not preferred in embedded sql programs?
What is cursor stability?
What is subquery ?
Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......
What is package in db2 mainframe?
What is concurrency?
Which isolation level provides maximum concurrency?
Which transaction use a command thread ?
COBOL 
