I have a main program (A) where we delete some rows in
table in a cursor, and we commit it in sub program(B).
What will happen - will we get an error or not?
Answer Posted / manikanta
Whenever control is going to sub program or control is coming back to main program - COMMIT takes place automatically by the system.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How can you find out the # of rows updated after an update statement?
How can the duplicate values be eliminated from db2 select?
How is deadlock resolved?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is innodb buffer pool?
What do you mean by commit and rollback?
Explain the contents that are a part of dclgen.
What is the use of value function?
What is buffer pool and list some of them?
Describe major components of db2?
What is dbrm?
What is copy pending status in db2?
What are union and union all?
Explain various types of locks in db2?
What is the use of db2?