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 |
What is the function of buffer manager?
What is bind package and plan in db2?
What can the Locate option of the Repair Utility accomplish?
List down the types of triggers in the db2 database?
what is static sql? what is dynamic sql? Give me details
Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.
What are some SQL aggregates and other built-in functions?
What is the syntax for creating a table in the db2 database?
What is sqlcode -811?
7 Answers Accenture, CTS, TCS,
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
How to find last record before record through SQLRPGLE?
What happens to the PLAN if index used by it is dropped?