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 is reorg?

619


Which component is responsible for db2 startup and shutdown?

628


What is host variable?

595


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

629


Why do we need reorg in db2?

564






How do you simulate the explain of an embedded sql statement in spufi/qmf?

634


What is database manager in db2?

551


How do we specify index to include or not during bind process.

1674


Describe major components of db2?

640


What are concurrency issues?

629


Mention the downsides of page level lock.

707


What are the different types of base tables?

585


For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

658


What is database reorganization?

589


What is the use of with ur in db2?

615