Answer Posted / 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 |
Post New Answer View All Answers
how do you use commitment control in rpg?
how does the rpg element work?
how do I declare a table or array in rpg iv?
When it is desirable to describe files Internally?
what are the key words you must use when using a subfile?
What is a record lock error?
what is the necessary keyword needed to scroll subfile records?
are there any useful c runtime apis that I can call from rpg iv?
can I touch the array during treatments?
Please tell me how to read the records from a file with load an array of size with error conditions(The logic answer for this question is ARR is array of 99 elements Z-ADD 0 IDX *LOVAL SETLL FILE READ FILE 99 *IN99 DOWEQ *OFF IDX ANDLT 99 ADD 1 IDX MOVE FIELD ARR,IDX READ FILE 99 ENDDO).So,Please give me the complete of this code.
is this a rpg channel?
Explain mdt?
What is difference between bind by copy and bind by reference?
1. What is bound-by-call and bound-by-reference? 2. Where and why is *Nomain used? 3. What are the difficulties faced by programmers when using service programs? 4. Explain the different ways of parsing and compiling XML in iSeries.
what is an online rpg?