wat is curser?? and its types???
Answers were Sorted based on User's Feedback
Answer / gss
Cursor we can define as pointer to the records of database
where we can fetch the records depending on varios
conditions or even sequential.
Is This Answer Correct ? | 10 Yes | 2 No |
Answer / abhijeet m
Simple cursor (Only one fetch operation per record )and
Scrollable cursor (Can be moved up or down of cursor result
set)
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / 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 |
what is the difference between SETON RT & RETURN?
3 members in databasefile .how to read records from all the members??
How to update selected fields from pf without using update opcode. How to read all member in Rpg-3,without using any cl command?
Can an indexed file be accessed in arrival sequence in RPG?
use of PUTOVR,OVRDTA,KEEP keywords?
What is ment by record level identifier?
I know whole thing ab't Arrays related to declaration..can anyone tell me what exactly use of array or anyone faced a situation where he found use of array must....
what are the types of identifers
What is the difference between iter and do?
I have file with data as follows data 1 2 3 4 5 I need to read 1 and 5 ,then 2 and 4 then like.. upto end of file, can any one help on this
what is ment by "MDT"
Delete FileName at first statement in RPG.