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 |
We know that size of redefine and redefining need not to be same..Then does the below case true 01 ws-date pic 9(6). 01 ws-redf-date REDEFINES ws-date 05 ws-year pic 9(4) 05 ws-mon pic 9(2) 05 ws-day pic 9(2)
what is the use of comp2 ? where can we use it with example ?
I have dataset DS1 which has records say 1 2 3 4 5 ... ... etc And also I have second dataset DS2 whcih has records 1 3 4 5 6 8 .. ... Both the files are sorted and now I want to compare these files and write it into the third files if the records are matching.
01 text-data pic x(100). move 'xyzdbfrjjg u' to text-data. how to find the value of last index of text-data?
how do you move only numeric data from A to B 01 A pic x(10) value 'a1b2c34d5e'. 01 B pic x(5).
if one main program ,n -subprograms are then which call you follow ?why reasonuhg
how to refer the data field?
WE HAVE 2 FILES IN COBOL. ONE IS FIXED LENGTH RECORDS ANOTHER ONE IS VARIABLE LENGTH. IF I DECLEAR LRECL OF FIXED ONE AS 80 AND 2ND RECORD AS 132. WHAT WE NEED TO DECLEAR LRECL FOR THOSE 2 FILES IN JCL?
consider the following PROCEDURE DIVISION entry OPEN EXTEND IN-FILE identify the correct statement a.organization of IN-FILE is sequential and records can be added in the beginning b.organization of IN-FILE is sequential and records can be added in the end c.organization of IN-FILE is indexed and records can be added in the beginning d.organization of IN-FILE is indexed and records can be added in the end
why do u need inspect verb?
how many bytes do SPPPP999 will store?
Please let me know at which Scenarios we will go for STATIC call or DYNAMIC