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

In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?

8 Answers   Syntel,


What is the reason behind not using select * in embedded sql programs?

0 Answers  


What does db2 stand for?

0 Answers  


What is null in db2?

0 Answers  


how do you resolve -805?

3 Answers   HCL,


What is isolation level in db2?

0 Answers  


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

0 Answers  


What is multi row fetch in db2?

0 Answers  


What is db2 stogroup?

0 Answers  


What is index cardinality?

3 Answers  


What is a base table?

2 Answers  


What keyword does an SQL SELECT statement use for a string search?

2 Answers  


Categories