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.

Answer / abhijeet m

Simple cursor (Only one fetch operation per record )and
Scrollable cursor (Can be moved up or down of cursor result
set)

Answer / kamal

declare cursor
open cursor
fetch cursor
close cursor

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

In case if I want to know whether a record exists in a file, which one do you prefer CHAIN or a SETLL and why ?

1 Answers  

---

how do I declare a table or array in rpg iv?

0 Answers   IBM,

---

Suppose in CL we reach at end of file and again we have to reach from 1 record

3 Answers   TCS,

---

i 'm new to as/400.in an interview i was asked this question.give a practical example for passing information or data through local data area. I know only that data area is an object used to store tiny bits of data or it can store one value at a time and it is used to store frequently changing values or datas.thats all i know about data area can any one tell me how local data area and user defined data area are used to pass data between jobs with a example or coding.thanks in advance.

2 Answers   CTS,

---

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 is the name of default out queue when user logs inn to syatem with valid profile?

3 Answers   IBM,

---

Is it possible to call a subfile using CL. IF yes.. kindly help me out with explanation...?

3 Answers  

---

I want my simple Green screen should refersh every 1 min ,How can I do it..? Please share the logic

2 Answers  

---

How to read alternative records in a pf by using rpg?

8 Answers   IBM,

---

Maximum how many files declare in rpgle

3 Answers   TCS,

---

In how many ways a session/device error occurs,,, and what is the remedy for it?

3 Answers  

---

How do you know if a record exists without doing a READ and CHAIN?

6 Answers   IBM,

---