wat is curser?? and its types???
- 4 Answers
- 10788 Views
- HSBC, I also Faced
- E-Mail Answers
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 |
How to search particular records from the database file in rpg?
Can anybody tell me, does CL/400 handle LEVEL check while running the CL program....? plz share your experience...
A particular job executing on the iS is not behaving as expected and is operating in an environment in which it can be debugged. What commands would you use to debug and observe the program?
what is a rpg?
If I have a file with 5 record and that file has 2 Key field and I want to read the unique record of the file then how can we achieve it?
wat is meant by hidden field , why it is used?
Why we cannot call a service program? If I add a PEP can i call the service program?
am 2010 passed out . can any one tell me which course is good to put 2+fake .guide me
How to get only unique records from a file which contains duplicate data using CPYF command ? Example : FILEA has duplicate records and FILEB is a UNIQUE defined.... and I want to get the data from FILEA to FILEB by eliminating all the duplicate records...
I know chain keyword retreive records randomly but how chain keyword exactly works internally????
thanks mr.Harshad R Suryawaunshi,i'm new to as400 i think you are telling in rpgile i know only rpg400 if possible can you tell in rpg400
Delete FileName at first statement in RPG.
RPG400 
