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 |
Assume my file has 100 records and I want to see only first 10 records. Is this possible through lf?
What is I90(Insure 90)?
How to create a login screen using a command instead of display file.... intention is to get a password field on a command..... how do you achieve this...
Can we trigger an rpg program which has user interaction with display file when updating a file using the command ADDPFTRG?
How do you do indexing in a physical file?
how do I do concatenation in rpg iv, like I do in cl?
3 members in a databasefile .how to read records from all the members?????????
A pgm subroutine calling child subroutine, that child subroutine again calling parent subroutine, u have 1000 lines of code, with out debugging , how can u find that error??? Is there any command to find errors in pgm???
Can anybody tell me that why we use option(*nodebugio)in H- Spec?
What is the difference between RPG/400 and RPG4
How do you find out whether a record is present in the physical file without reading the file? for Example Employee No: 100 in an Employee master.How do we find out whther 100 is present in Employee master without reading the file?
11 Answers Bank Of America, CSC, IBM,
what is file identifier wher we can use