Interested to Buy Any Domain ? << Click Here >> for more details...
wat is curser?? and its types???
- 4 Answers
- 12371 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 |
What is difference between bind by copy and bind by reference?
how can i retrieve the field name from display file at run time? Devendra Singh Tomar
1. If my rpg program has a date field, What extra care I have to take while compiling that RPG program? 2. 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?
do you use message subfiles? What are the necessary keywords required coding a message subfile?
are there any useful c runtime apis that I can call from rpg iv?
Can anybody tell me, does CL/400 handle LEVEL check while running the CL program....? plz share your experience...
In how many ways a session/device error occurs,,, and what is the remedy for it?
Can a run time array be declare like below with no specified number of elements ? Is it possible ? DFLD_ARRAY 7 DIM() INZ(*blanks) What does this mean ? Does this mean that the number of array elements will be dynamically declared during run time ?
In case if I want to know whether a record exists in a file, which one do you prefer CHAIN or a SETLL and why ?
what is the use of sflnxtchg?
What are different ways to pass data between programs and which one is the efficient way?
what is the equivalent keyword for CHAIN opcode ??
RPG400 
