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
Answer / swati
If Sub-Program executtion is terminated,cursor is
automatically closed.
| Is This Answer Correct ? | 23 Yes | 1 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 |
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 |
a. Can the OPTIONAL clause in COBOL only be coded for input files? b. If it is coded for files opened in OUTPUT, I-O or EXTEND mode, will it give a compilation error? c. If there are no compilation errors and if such files are not coded in the JCL, will the OPEN statement run fine when these files are opened? d. How will a WRITE statement work for the above files?
I have to write to a outfile where the number of records in that file should be the header of that file using IMS.. can anyone help me in this issue
What is a subscript ?
wht is packed decimal in cobol
how to know that the file has 300 records how to acess it?
how do you reference the printer file formats from cobol programs
How to resolve the soc4 & soc7 other than following answers. Soc4 can resolved using mispleed dd name and dd name is not matching with file and soc7 check the sysdump and copy the offest address then correct it in the program.
10 Answers ADP, Amdocs, Cap Gemini, Keane India Ltd, Super Value, TCS,
In my table having 3000 Records. How can I delete the 500th row? (we don't know what is data inside the table)
ID DIVISION. PROGRAM-ID. PLO. DATA DIVISION. WORKING-STORAGE SECTION. 01 VAR1 PIC 9(2). 01 VAR2 PIC X(2). PROCEDURE DIVISION. ACCEPT VAR2. MOVE VAR2 TO VAR1. STOP RUN. if i give 'PI' in var2 then what will b output of progr. any abend?????
Can we move X(9) to 9(9). If yes what are the ways for doing this?
What is Static,Dynamic linking ?
01 a pic 9(6) value is 123456 01 b pic 9(3) move a to b wht will be the value ?