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
What is a system catalog table in db2?
What is the meaning concurrency in the db2 database?
What does reorg do in db2?
Explain packages.
How do I add a column to an existing table in db2?
Outputs of explain are with matchcols = 0. What does this signify?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is a Foreign Key?
What is an instance in db2?
What parameters are used to control the free space in DB2?
What is blu acceleration in db2?
Can you use max on a char column?
Mention the downsides of page level lock.
How do I add a column in db2?
What is dbrm? What it contains?