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 |
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?
What is the reason behind not using select * in embedded sql programs?
What does db2 stand for?
What is null in db2?
how do you resolve -805?
What is isolation level in db2?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is multi row fetch in db2?
What is db2 stogroup?
What is index cardinality?
What is a base table?
What keyword does an SQL SELECT statement use for a string search?