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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to read the 2nd last record of a VSAM file? (The file size is huge and we don't know the key)

2725


I have File 1 occurs 5 times with Employee-ID,Employee-Name,Employee-Dept (EEE and MECH). I have File 2 occurs 10 times with Employee-ID,Employee-Name,Employee-Dept (EEE,CIVIL,CHEMICAL and MECH). In FIle 1 and FIle 2 , for matching Employee-DEPT (Only MECH) , we need to move entire records from file1 to file 2. We should not use 2D array. Your help is needed here.

1121


Difference between array and sub-script ?

1169


How to get the last record in vsam file in cluster? And how can you get the kids file records into your cobol program?

744


i was faced one question- i have value -00001234.56 Suppress the zeroes and the output should be -1234.56 But Not - 1234.56 spaces should not be available after suppressing the zeroes. logic in jcl and cobol?

897






What is amode(24)?

684


What is the difference between structured cobol programming and object alternativelyiented cobol?

757


i have 10 names in an array and my name is one of them also array is not in sorted order i need to display my name using index how will i do this

1000


What rules are followed by the search verb.

638


What do you understand by psb and acb?

668


Which Search verb is equivalent to PERFORM…VARYING?

691


What is the difference between Global and External Variables?

666


What is an in line perform? When would you use it? Anything else you wish to say about it.

649


Have you used the sort in your project?for this type of questions any working on real time project give the eg. with real time scenario.

2062


How arrays can be defined in COBOL?

667