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?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / ananth
I dont know about this question?
Please let me know if you gave answer
Is This Answer Correct ? | 0 Yes | 2 No |
How do you do the EXPLAIN of a dynamic SQL statement?
What is a subselect? Is it different from a nested select?
What does CURRENTDATA option in bind indicate
How do you insert a record with a nullable column?
What is RUNSTATS?
Can you access the DB2 Directory table using SQL?
What is the role of data manager in the db2 database?
What is package versioning? Please give an example.
What is dpf in db2?
Where are plans stored?
Can any one tell me about Restart logic in DB2.
Where do you specify them?