when we are trying to update db2 rows. if the program
abends . how we will know that the last successful update
row was

Answer Posted / ramesh m

You can do the select query and in where condition, you
have to query for current timestamp for the particular row.

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the contents that are a part of dclgen.

851


Can we insert update delete in view?

748


What is the use of reorg in db2?

807


Mention the location where the output received from explain statement is stored.

838


What is a Foreign Key?

842


In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

834


Define predicate?

845


How can you count the number of rows from a table tab?

829


Why db2 is called db2?

762


What is phantom read in db2?

817


How can we retrieve the total number of records in RPG & CLLE?

361


What is table space in db2?

770


What is schema in db2?

760


While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2068


What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

960