what happens if we dont close cursor in db2-cobol pgm?
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
Differentiate cobol and cobol-ii. (Most of our programs are written in cobolii, so, it is good to know, how, this is different from cobol)?
) How do u handle errors in BMS macro
Explain what you understand by passing by value.
What are the pertinent COBOL commands?
Name the divisions, which are available in a cobol program?
What are declaratives and what are their uses in cobol?
What is the difference between a binary search and a sequential search what are the pertinent cobol?
What are the access modes of START statement?
Explain the configuration section of a cobol program with examples of syntax.
how do you reference the variable block file formats from cobol programs
What rules are to be followed while using the corresponding options?
Define cobol?
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.
What is the problem of ordered sequential files access?
Explain how will you differentiate between an internal and an external sort, the pros and cons, internal sort syntax etc