Interested to Buy Any Domain ? << Click Here >> for more details...
wat is curser?? and its types???
- 4 Answers
- 12563 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 |
Hi,This is raju.Can any body give me the real experience answer for this question? 1.What is the significance of *MAP and *DROP in the CPY command?
How can a screen field that has changed since the last output operation be detected?
What is the compilation option that has to he specified while compiling an RPC program which uses a file having date data type field?
i would like to know under what circumstance the object will get locked on AS400.
difference between 1:%found and %equal built function in detail with example .
how does the rpg element work?
what are the key words you must use when using a subfile?
How can we override a file during runtime in RPG? Without using OVRDBF or calling a CL program
When PGMA calls PGMB for the first time PGMB executes the *INZSR. PGMB uses the RETRN operation to return to PGMA. When PGMA call PGMB the second time is the *INZSR executed?
1.Suppose my file has 10 fields and I want to make the 2nd field Zeros in all records. And assume I have millions of records and I dont want to read each record and update the desired field with 0. Any other way to do this in one step operation? 2. Assume my file has 100 records and I want to see only first 10 records. Is this possible through LF? 3.I have 3 jobs A B and C. I want to submit B after successful completion of A and want to submit C after successful completion of B. Without using job scheduler or job queue, how can i do that through CL program? 4.What is difference between Bind by copy and bind by reference?
what was the robotech rpg?
where we give the MSGSFL in rpg400?
RPG400 
