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

Can you please let me know the centre name of INS certification in Kolkata.

1936


I have a program with an Array of 5000 occurences which is being passed from 5 sub levels to the front end screen. Thess 5 programs using each 5*2 = 10 different arrays with size as 5000. This is causing the transaction to utilize more storage consupmtion. I am looking to reduce the storage consumption. As part of that initially i thought Dynamic array may solve my problem. After viewing the comments given i see its same as normal array. IS there any other way we can resolve this issue?

1397


Can we change the password using ALTER? anyone tried and changed?

1733


What are literals?

833


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

857






how to refer the data field?

1981


How to fetch 1000 error records from VSAM file(Eg: 1000000 records present) while getting SOC7 abend ?

2214


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

941


if we have " ibm mainframe ",in that how to remove first and last leading space eg:"ibm mainframe" like that the answer we need

1051


Which mode is used to operate the sequential file?

908


What is the difference between PIC 9.99 and 9v99 in COBOL?

959


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?

1068


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

895


What is perform what is varying?

903


What are the different rules for performing sort operation?

939