when i am trying to update a table having 1000 rows. the
program abends.how we will come to know the last successful
updated row was. we are not using any commit operations
Answer Posted / girish kumar
if u want to update ur changes to the database, posible when the commit is executed or when the program successfully executed. none other any situation database will not update.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How connect db2 database to datastage?
What is collection in db2 bind?
Can you tell me how can you find out the # of rows updated after an update statement?
How and when does the db2 enforces the unique key?
What is the cobol picture clause of the db2 data types date, time, timestamp?
How to create db2 table in mainframe?
How to fetch the last row from the table in SQL (db2)?
What is node in db2?
What is meant by explain?
Why do chiropractors use drop table?
What is blu acceleration in db2?
can we view the access paths created by dbrm ? how ? thx
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 ?
Is db2 free?
What are the 2 sqlcodes that are returned?