How can you quickly find out the number of rows updated
after an update statement?

Answer Posted / vamshi

check for the value is in sqlerrd(3). it contains the no.
of rows updates.

Is This Answer Correct ?    23 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can the duplicate values be eliminated from db2 select?

623


What is a db2 table?

595


How would you find out the total number of rows in a db2 table?

576


What is temporal table in db2?

601


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

579






What do you mean by storage group (stogroup)?

583


Can one database have multiple instances?

581


Name the various locking levels available?

632


How can you do the explain of a dynamic sql statement?

635


What is access path in db2?

562


What is the maximum length of sqlca?

869


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2375


What is a plan and package in db2?

621


Is db2 free?

684


What os does db2 run on?

570