Interested to Buy Any Domain ? << Click Here >> for more details...
what happens if we dont close cursor in db2-cobol pgm?
- 6 Answers
- 27114 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 amode(24), amode(31), rmode(24) and rmode(any)?
1.What is the limit of linkage section?
why do u need inspect verb?
What is difference between static and dynamic call in cobol?
how to submit a jcl by cobol program. clear me with an example.
I have a files containing both duplicate and non-duplicate records.The file is already sorted by a key.I want to determine those records that are duplicate and records that are non-duplicate.If duplicate the record is move to a duplicate file and if non-duplicate that will be move to valid file.thank you
What is an index for tables?
What are the pertinent COBOL
How to read the 2nd last record of a VSAM file? (The file size is huge and we don't know the key)
can u plz expain me how to declare dynamic array? what is the meaning of depending on clause in dynamic array?
How do u know what version of cobol u are using?
diffrence between z(2) and z9(2)
COBOL 
