Interested to Buy Any Domain ? << Click Here >> for more details...
what happens if we dont close cursor in db2-cobol pgm?
- 6 Answers
- 27490 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vaid
i think, if we dont close a cursor there will be no problem.
since once the program ends all the database
transaciton/connections are terminated and also commit is
implicitly executed.. so the cursors will be closed.
and all resources held by program will be released.
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / manju
When the COMMIT stmt is issued, the cursor is atomatically
closed.
| Is This Answer Correct ? | 11 Yes | 2 No |
Answer / i go crazy
If the cursor is declared WITH HOLD option, then after committing cursor will not close. Otherwise cursor will close automatically after committing or after the end of the program.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / swamy
If you dont close cursor in your db2-cobol program, the
program will effectively have a hold on the tablebase and will
prevent other users from acessing it or updating it. Correct
me if i am wrong
| Is This Answer Correct ? | 6 Yes | 5 No |
Answer / karthic
If the cursor has not been closed, the cursor will occupy
the whole private SQL work area. The next query performance
will be affected.
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / vinodquestion
I am not confident about this answer::
I think no problem when u not close cursor. But problem occurs when you again OPEN CURSOR.
When this happen some cursor related errors occurs. I think 502 will show. I Dont know exactly.
Please Correct My answer if it is wrong.
| Is This Answer Correct ? | 2 Yes | 5 No |
what is the basic concept of mainframe? what knowledge is needed for learn this mainframe?
what is the difference between external and global variables?
What divisions, sections and paragraphs are mandatory for a COBOL program?
what are the utilities for load and unload the DB2 tables
wht happens if we dnt give scope terminator ?
Explain call by context by comparing it to other calls.
What do you feel makes a good program?
01 a pic 9(6) value is 123456 01 b pic 9(3) move a to b wht will be the value ?
what is label record is standard or omitted in file description of data division?
Hai friends why we need to read a file before re-write a record?
How is sign stored in Packed Decimal fields and Zoned Decimal fields?
) How do you access the migrate the data from production region to development region
COBOL 
