in a table consist of 1000 records among that i was updated
145 record how could i know that ..list of recently updated
record's and where could i see those updated
record's....pls help me out....

Answer Posted / girihs kumar

SQLERRD Contains the number of rows affected by a DB2
INSERT/DELETE operation. if the operation is DELETE, this
contains number of rows deleted after the execution of the
query.

Is This Answer Correct ?    16 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

734


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

642


Explain in brief how does db2 determine what lock-size to use?

606


What are the two types of logging in the db2 database? Explain them.

586


What is dbrm? What it contains?

688






What is bind plan?

623


How do I add a column to an existing table in db2?

604


What is db2 bind?

646


What are iseries servers?

574


What is cursor with hold option in db2?

622


How to test SQL -911 error while developing COB-DB2 program

6732


What is the use of with ur in db2?

627


What is consistency token in db2?

652


What is package in db2 mainframe?

565


What is the difference between plan and package in db2?

585