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
Why do chiropractors use drop table?
Is the primary key a clustered index?
What is null value in db2?
Explain package in db2 and its advantages?
What are the full forms of spufi and dclgen and why are they used?
What is sqlca?
What is db2 bind process?
How do I create a view in db2?
What is the meaning concurrency in the db2 database?
How to find the maximum value in a column in the db2 database?
What is syscat in db2?
How do we specify index to include or not during bind process.
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
Which component is responsible for db2 startup and shutdown?
What is catalog database in db2?