what happens if we dont close cursor in db2-cobol pgm?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

i want a program using by if, evaluate , string, unstring, perform, occurs?

4061


how do you reference the esds vsam file formats from cobol programs

634


How do u write test cases?

1638


In COBOL programming, what is PERFORM? What is VARYING?

672


Write some characteristics of cobol as means of business language.

619






What are the different types of condition in cobol and write their forms.

658


How did the release of cobol/370 version 1.3 improve the performance of release 1.1?

645


Difference between array and sub-script ?

1167


how do you reference the rrds file formats from cobol programs

800


What are the various section in data division and briefly explain them.

699


how do you reference the fixed unblock file formats from cobol programs

712


how do you reference the variable unblock file formats from cobol programs

748


input 1 input2 ouput1 output2 output 3 1 re 300 1 re 200 1 re 300 3 rc 500 1 re 200 2 rr 400 1 re 300 2 rr 400 1 rc 400 3 rc 500 1 rc 400 2 rr 700 2 rr 700 5 tt 900 5 tt 900 2 inputs r in flat file and output 1 is matched records,ouptput2 is unmatched of input1,output3 is unmatched of input2! how vl u get the output files using sequential order and to check with each and every records! let me know the procedure division ?

1876


Which is the default, TEST BEFORE or TEST AFTER for a PERFORM statement?

825


Explain about different table spaces.

650