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



I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub ..

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

I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub ..

Answer / ananth

I dont know about this question?

Please let me know if you gave answer

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More DB2 Interview Questions

What is the function of buffer manager?

1 Answers  


What is bind package and plan in db2?

1 Answers  


What can the Locate option of the Repair Utility accomplish?

2 Answers  


List down the types of triggers in the db2 database?

1 Answers  


what is static sql? what is dynamic sql? Give me details

3 Answers  


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.

9 Answers   Cap Gemini,


What are some SQL aggregates and other built-in functions?

2 Answers  


What is the syntax for creating a table in the db2 database?

1 Answers  


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?

1 Answers  


How to find last record before record through SQLRPGLE?

1 Answers   IBM,


What happens to the PLAN if index used by it is dropped?

1 Answers  


Categories