what happens if we dont close cursor in db2-cobol pgm?
- 6 Answers
- 24745 Views
- I also Faced
- E-Mail Answers
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
There are 5 fields and 1000 records in a file. Unload it into an array. Write the syntax for declaration and how will you unload it.
What is difference between static and dynamic call in cobol?
How to print 10 to 1 if the input have only 10 digit number?
Program A (Normal COBBAT) calling a B Program (DB2COBOL, COBBATDB which is using a VSAM file. its a dynamic call. How we will handle VSAM file decleration in our from JCL from where we are running A PGM. And should we have PLAN for A pGM also. if possible can some one post a sample JCL. Thanks for help in advance.
how do you reference the variable block file formats from cobol programs
Can a Search can be done on a table with or without Index?
if we display var1 then what will b displayed in below condition. 77 var1 pic s9(2) value -10. 77 var1 pic s9(2) value -11. " " " -12. " " " -13. -14 ... ... -19.
What kind of error is trapped by on size error option?
In COBOL programming, what is PERFORM? What is VARYING?
What is link edit in cobol?
What rules are to be followed while using the corresponding options?
how can we apply for HSBC exam(Mainframe) in India??? i went to their site and was told to submit my CV ,. etc..( totally confusing...)
What type of SDLC u followed? Why?
What is amode(24), amode(31), rmode(24) and rmode(any) (applicable to only mvsesa enterprise server) ?
Write down the divisions of cobol program?
