I have a Main Program which is calling Sub-Program which is
a DB2 pgm. What will happen if I am not closing the cursor
used in the Sub-program? Please advise..

Answer Posted / abirami

If you do not close the cursor it might give warnign
message, But it will not fail, When you try to open next
time it will give error that cursor is already opened, and
you are tryign to open the same

Is This Answer Correct ?    0 Yes 13 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

1071


Are you comfortable in cobol or jcl?

805


)If there are 10 steps in GDG, if I want to refer the step2 after step5 . what should I do?

1740


Name the divisions, which are available in a cobol program?

919


What are the cobol coding sheets?

864


What is the difference between Call and a Link?

885


What are all the divisions of a COBOL program?

883


What is length is cobol?

858


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

867


can anybody post me about file-aid and changemen tools pls and give me reference if any mainframe guys are there

2114


which is Best IBM Mainframe Training and Placement Institute in Ameerpet Hyderabad

1236


Why is it necessary that file needs to be opened in I-O mode for REWRITE?

983


What is rmode(24)

895


what is s000 u4087 error? please give the all error codes in cobol,jcl.

17508


What are the different rules to perform a Search?

809