Why we should use cursor ?
Answers were Sorted based on User's Feedback
Answer / randy
By Using Cursor, we can fetch more than one record from database.
| Is This Answer Correct ? | 0 Yes | 0 No |
Cursor is used to fetch more than one row at a time from db2 table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / manhem
To fetch more than one row from DB2 table, Cursor is used
| Is This Answer Correct ? | 0 Yes | 0 No |
What is amode(24), amode(31), rmode(24) and rmode(any) (applicable to only mvsesa enterprise server) ?
What is the difference between Call and a Link?
SSRange is used to do a range check on which of the Following. SUBSCRIPT,INDEX,REFERENCE MODIFICATION,Run-time option.
what are the isolation levels and where we use it in the db2 program
Consider the following COBOL entries: 05 X PIC 99 VALUE 10. SUBTRACT 20 FROM X. The resultant value of X wil be
HOW WE WILL SORT THE ARRAY WHICH IS GOING TO USE FOR SEARCH ALL?
01 a pic 9(3) value is 123 01 b pic 9(6) move a to b wht will be the value ? and 01 a pic x(6) value is abc 01 b pic x(3) move a to b wht will be the value ?
how do you reference the fixed unblock file formats from cobol programs
1.Can we define condition-name conditions in FD entry.
Is this allowed? 01 WS-TABLE. 03 FILLER-X PIC X(5) VALUE 'AAAAA'. 03 WS-EX REDEFINES FILLER-X OCCURS 5 TIMES PIC X(1). can redefines clause be used with occurs clause?
In a program, there are 2 sections defined say SECTION-A and SECTION-B. There is a paragraph say CALC-INT in both the sections. If this para has to be called directly for SECTION-A, then PERFORM CALC-INT will not work as it is present in both sections. How the PERFORM statement has to be coded here?
01 a pic x(4) value 'abcd' 01 b pic 9(3) can we move from a to b.if possible what would be stored in b.