Answer Posted / gagan
A cursor is a temporary area of storage that is used to hold the information that is retreived from the SQL select statements.A cursor is mainly used to point to the table retrieved as a result of select query.
Types of cursor :
Serial cursor: In this the rows retreived from the resulting table are in sequential order .Also once EOF is reached the cursor can not be repositioned
Scrollable cursor:In this the rows retreived are based on the position mentioned on the FETCH statement
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
If my rpg program has a date field, what extra care I have to take while compiling that rpg program? If the file is keyed and I have declared the file as well as key list properly in my program. Still am getting an error message like "chain/reade operation is not allowed" what may be the case?
what is the necessary keyword needed to scroll subfile records?
How to handle duplicate error handling in RPG?
what is program status data structure?
what is the difference between do while and do until?
How to write record if no field or the field are different in physical file in rpgle ?
what is data area and how it is used in rpg program ?
How can we override a file during runtime in rpg?
what was the robotech rpg?
When we have a file with Duplicate records and I want to read the unique record from the file. For example a file containing Emp Name as 'Ram' and there are 3 entries of it. So how to read a unique record from File?
What is the difference between iter and do?
how do I play {insert rpg system here}?
if there is a module object , how to find the program object for this module object.Assume the module object name and program object name is not same.
how do you use commitment control in rpg?
What is a record lock error?