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 |
what is flat file?
in which journalling which attributes are necessary??/
I want my simple Green screen should refersh every 1 min ,How can I do it..? Please share the logic
how to find whether a date format is valid or not in RPG400 not in RPGILE.Can you please write the coding for this sir,i'm new to AS400.Please help.
Can an indexed file be accessed in arrival sequence in RPG?
Anyone help me for the below question:- If problem/error occur in *PSSR subroutine,how should I handel it in RPG program.
what is the necessary keyword needed to scroll subfile records?
1.How to read a subfile in out put mode? 2.what are the keywords used to share same file? 3.using composite key which rpg code used?
use of PUTOVR,OVRDTA,KEEP keywords?
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.
can i use UPDDTA command in rpg program in which contains a file
in which journalling which attributes are necessary