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..

Answers were Sorted based on User's Feedback



I have a Main Program which is calling Sub-Program which is a DB2 pgm. What will happen if I am no..

Answer / swati

If Sub-Program executtion is terminated,cursor is
automatically closed.

Is This Answer Correct ?    23 Yes 1 No

I have a Main Program which is calling Sub-Program which is a DB2 pgm. What will happen if I am no..

Answer / subhani

DEAR DUDE ABIRAMI DONT GIVE WRONG ANSWERS PLEASE.... SO MANY
PERSONS PREPARE FOR INTERVIEW PLEASE I REQUEST TO U........

Is This Answer Correct ?    1 Yes 0 No

I have a Main Program which is calling Sub-Program which is a DB2 pgm. What will happen if I am no..

Answer / 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

More COBOL Interview Questions

Explain about Redefines cluse?

3 Answers   iGate,


can we use the two 01 level in file discription ?

6 Answers  


At the minimum, which division of COBOL is enough to be coded?

3 Answers   CTS,


how to check whether the open command of a sequential file is successful? or not?

2 Answers   CSC, IBM,


What are INPUT PROCEDURE and OUTPUT PROCEDURE?

0 Answers  






01 var1 pic x(10) 01 var2 redefines var1 pic 9(10). then in procedure division move 'abcde' to var1 then waht is the value of var1 and var2

9 Answers   HSBC,


I have a files containing both duplicate and non-duplicate records.The file is already sorted by a key.I want to determine those records that are duplicate and records that are non-duplicate.If duplicate the record is move to a duplicate file and if non-duplicate that will be move to valid file.thank you

1 Answers  


what is the coding difference between COBOL and CICS.

8 Answers   Cap Gemini,


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?

0 Answers   HCL,


what is difference between the sysabend and userabend?

2 Answers  


Can JUSTIFIED be used for all the data types?

3 Answers  


There is a variable with value 19446. Requirement is to convert it to 194.46. I tried it by doing divide by 100 and my receiving field data type is 9(03)v99. But the output is 194. I am not getting the decimal value. Could anyone pls let me know how to get this done?

2 Answers  


Categories