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 |
What is the mode in which you will OPEN a file for writing?
Study the DATA DIVISION entries and the three PROCEDURE DIVISION entries given below: 01 END-OF-FILE-SWITCH PIC XXX. 88 NO-MORE-RECS VALUE "YES". 88 MORE-RECS VALUE "NO". (i) READ SAMPLE-FILE AT END MOVE "YES" TO NO-MORE-RECS. (ii) IF NO-MORE-RECS = "YES" GO TO LAST-PARA. (iii) IF NO-MORE-RECS GO TO LAST-PARA. Which are wrong? (a) (i) and (ii) (b) (ii) and (iii) (c) (i) and (iii) (d) all
Which is the default, TEST BEFORE or TEST AFTER for a PERFORM statement?
SIGN TRAILING SEPARATE field occupy ?
I need to compare 3 variables(dates) and do some processing based on the earliest date. There could be more then 1 date record in any of the 3 fields. What is the best way to code this?
what is call by value and call by reference ?
3 Answers Infosys, ITC Indian Tobacco Company,
given the following piece of code: CALL SUB-PGM USING A, B, C. CALL SUB-PGM USING A, C, C. (a) Both CALL statements will always produce same result. (d) Both CALL statements may produce different result. (c) Compile-time error because SUB-PGM is a dataname. (d) Compile-time error because A, B, C are used twice.
can you declare redefine in level 01?
What is rmode(24)
without performing any operations on a file how can i know whether it contains data or not
Have you used comp and comp-3 in your project? And how?
What is the compute verb? How is it used?