If we donot code the 'CLOSE CURSOR' statement then when the program finishes successfully it will automatically close the cursor and release all reources held by it.
Question 1: If I open this cursor again in another program will there be any error code? If yes what error code?
Question 2: If the program terminates unsuccessfully, will the cursor still get closed?
Question 3: If the cursor is declared with 'HOLD' option, will the program will still be able to close it?
I donot have access to DB2 so I am not able to try this out.. Can any pls reply?