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

How do you do the EXPLAIN of a dynamic SQL statement?

2 Answers  


What is a subselect? Is it different from a nested select?

1 Answers  


What does CURRENTDATA option in bind indicate

1 Answers   IBM,


How do you insert a record with a nullable column?

2 Answers  


What is RUNSTATS?

3 Answers  






Can you access the DB2 Directory table using SQL?

3 Answers  


What is the role of data manager in the db2 database?

0 Answers  


What is package versioning? Please give an example.

1 Answers  


What is dpf in db2?

0 Answers  


Where are plans stored?

2 Answers  


Can any one tell me about Restart logic in DB2.

2 Answers  


Where do you specify them?

0 Answers  


Categories