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 does DSNDB07 database do?

2 Answers  


How to find the number of rows in db2 tables?

0 Answers  


What is -904 sql code? How to resolve it?

3 Answers  


I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).

10 Answers   Cap Gemini, Wipro,


How do you find the maximum value in a column in db2?

0 Answers  


What is the difference between nvl and coalesce?

0 Answers  


Q4. How will you get the count of record without using COUNT verb in query?

2 Answers   IBM,


Explain the contents that are a part of dclgen.

0 Answers  


What are the various locks available?

5 Answers   CTS,


How do I copy a table in db2?

0 Answers  


What are the bind parameters ibm db2?

0 Answers  


How does a cursor work?

0 Answers  


Categories