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 |
How to update physical file in rpgle without using display file?
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?
How to create a key field for a logical file inside RPG?
Anybody know the difference of primary file and full procedural file
The RP program is displaying records 11 times .But there are 10 records in a pf.(ie last record is displayed twice).How to display records only 10 times?
give an eg of ACQ-(ACQUIRE),BIT OFF,BIT ON,DEALLOC,DUMP,FEOD,FORCE,MHHZO,MHLZO,MHLLZO,MLHZO,REL,RESET,TESTZ,TESTB,TESTN----GIVE SMALL EXAMPLE TO THE OPCODES...TO UNDERSTAND FUNCTIONING...........
I want to declare the number of elements of an array dynamically in RPGLE ? Is it possible? If yes, then how do I do it ?
What is use of IMPORT and EXPORT in RPGLE ? What is activation Group ? What is Service Program ???? How to call another program in RPGLE ?
wat is the difference between array and multiple occurence data structure?
what is the rpg system?
difference between 1:%found and %equal built function in detail with example .
What is the length of Signature?