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
what is data area and how it is used in rpg program ?
Set on command is used for closed all opened files , initialize var and release resource , return cmd is used for return to calling program but my req. Is dnt close opened files and resource must released while doing transactions , how can i do this...?
What is the difference between copybooks and subprocedures in as400?
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.
What is a record lock error?
during execution, an rpg/400 program automatically follows a sequence of operations for each record that is processed. The built-in program cycle includes the following logical steps.
How many program bind in one module....
can I touch the array during treatments?
1. If there are two programs using same file and 2 users are using the file at the same time and what can be done to allow them both to access? 2. How can remove lock from the file for accessing it by both users?
can you debug ile rpg program using isdb?
How can we know running job is batch or interactive?
How can we override a file during runtime in rpg?
what is an online rpg?
Program to read marks of 10 students for 4 subjects and compute and display total marks and status of each student in rpg
explain sflclr, sflend, sfldlt, and sflcsrrrn?
