wat is curser?? and its types???

Answers were Sorted based on User's Feedback



wat is curser?? and its types???..

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

wat is curser?? and its types???..

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

wat is curser?? and its types???..

Answer / kamal

declare cursor
open cursor
fetch cursor
close cursor

Is This Answer Correct ?    7 Yes 6 No

wat is curser?? and its types???..

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

Post New Answer

More RPG400 Interview Questions

what is the difference between SETON RT & RETURN?

5 Answers  


3 members in databasefile .how to read records from all the members??

6 Answers   CTS,


How to update selected fields from pf without using update opcode. How to read all member in Rpg-3,without using any cl command?

8 Answers  


Can an indexed file be accessed in arrival sequence in RPG?

3 Answers  


use of PUTOVR,OVRDTA,KEEP keywords?

2 Answers   HCL,






What is ment by record level identifier?

0 Answers  


I know whole thing ab't Arrays related to declaration..can anyone tell me what exactly use of array or anyone faced a situation where he found use of array must....

1 Answers  


what are the types of identifers

2 Answers   IBM,


What is the difference between iter and do?

0 Answers  


I have file with data as follows data 1 2 3 4 5 I need to read 1 and 5 ,then 2 and 4 then like.. upto end of file, can any one help on this

3 Answers   ISG,


what is ment by "MDT"

2 Answers   TCS,


Delete FileName at first statement in RPG.

1 Answers  


Categories