Sign Up Login


  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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?

Question Posted / kumar

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 datacom db?

2 Answers   CSC,

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

0 Answers   Infosys,

How can you classify the locks in db2?

0 Answers  

How to view db2 table structure?

0 Answers  

What is meant by union and union all?

0 Answers  

What will the COMMIT accomplish?

5 Answers  

what's the best lock size that you could use when you create a tablespace?

2 Answers   IBM,

What is EXPLAIN?

1 Answers  

Can we insert update delete in view?

0 Answers  

How would you find out the total number of rows in a db2 table?

0 Answers  

What technique is used to retrieve data from more than one table in a single SQL statement?

9 Answers   CTS, IBM, TCS,

Can i insert bulk records into a db2 table using qmf of spufi only............!!!

2 Answers  

For more DB2 Interview Questions Click Here
Categories