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
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
How can you quickly find out the # of rows updated after an update statement?
Explain in brief how does db2 determine what lock-size to use?
What are the two types of logging in the db2 database? Explain them.
What is dbrm? What it contains?
What is bind plan?
How do I add a column to an existing table in db2?
What is db2 bind?
What are iseries servers?
What is cursor with hold option in db2?
How to test SQL -911 error while developing COB-DB2 program
What is the use of with ur in db2?
What is consistency token in db2?
What is package in db2 mainframe?
What is the difference between plan and package in db2?