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
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 |
Answer / ananth
I dont know about this question?
Please let me know if you gave answer
| Is This Answer Correct ? | 0 Yes | 2 No |
What is the picture clause of null indicator variable?
How to take backup of table in db2?
When will you chose to run RUNSTATS?
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
What is difference between *omit and *nopass?
What is the maximum size of varchar data type in db2?
How to test SQL -911 error while developing COB-DB2 program
What is bufferpool in db2?
i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its
When do you specify the isolation level?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
How to create backup table in db2?