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 are the three DB2 date and time data types and their associated functions?
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
Explain about rct in db2?
What is RUNSTATS?
What is dbrm in db2 database?
is there any restrictions for unions ?
What are catalog tables in db2?
Is schema the same as database?
what is the use of commit ? and what is the syntax?
Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
What is the meaning of -805 SQL return code?