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

I have one ps file in which there are 3 fileds emp_no,emp_name and leave_app.this ps file information give the detail of employee which is going to apply for leave.suppose emp_no=113430,emp_name=ajay,leave_app=1 that means he is going to apply for 1 day leave.and accordingling the table in db2 will be updated means if he has that no of leave in his account then he will get dat leave and updated acc. in table(leave_balance=previous leave present in table-leave_app).Now i want to check whther the updated result is correct or not by comparing the two ps file using IEBCOMPARE or icetool so what is going to be the two ps file and how its is going to be compare.

2008


Give some examples of command terminators?

756


Name some of the examples of COBOl 11?

2681


how do you reference the rrds file formats from cobol programs

797


Write a program to explain size error.

673






what is search and searchall?what is the diffrence between them?give an best example?

5552


What happens when we move a comp-3 field to an edited (say z (9). Zz-)?

776


What is the difference between Global and External Variables?

666


What is the difference between external and global variables in COBOL?

813


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

708


What rules are followed by the search verb.

638


) How do u handle errors in BMS macro?

1427


What is difference between static and dynamic call in cobol?

777


Hi pls anybody tell me about " ANALYSIS DOCUMENT PREPARATION AND ESTIMATION OF TASK " (in real time project)."I want to update a sequential file in my project" for that purpose i need both structures i mean analysis document and estimation of task.

1701


What is the difference between a binary search and a sequential search what are the pertinent cobol?

735