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

How to find d key field of a pf that doesn’t have source physical file?

2 Answers  

---

Suppose my file has 10 fields and I want to make the 2nd field zeros in all records. And assume I have millions of records and I dont want to read each record and update the desired field with 0. Any other way to do this in one step operation?

1 Answers  

---

Hi Viewers can any body explain me how to update and ahange the already existed data in physical file using subfile ? please explain me with the code if possible?

1 Answers  

---

I have two sessions S1 & S2 under this 3 jobs(say j1,j2,j3 under session S1) And 2 jobs(Say j4, j5 Under session S2)is running. How many QTEMP & how many LDA will create for the same.

9 Answers   IBM,

---

wat is scan and check ? give me real time scenarios where we used these keywords in ur projects?

2 Answers   Four soft,

---

---

Can a run time array be declare like below with no specified number of elements ? Is it possible ? DFLD_ARRAY 7 DIM() INZ(*blanks) What does this mean ? Does this mean that the number of array elements will be dynamically declared during run time ?

1 Answers   TCS,

---

I have 1000 records in a file. I would like to generate 10 identical reports from this record with same format (structure of records) how do I do this?

1 Answers   IBM,

---

1.Coding in cl to send an message? 2..What is turnover and use? What are the different levels?

4 Answers   IBM,

---

Hi, Can anybody give me real sinario for SFLRCDNBR?with example?

2 Answers  

---

can you debug ile rpg program using isdb?

0 Answers   IBM,

---

can we use cl programming to update or delete physical files

12 Answers  

---

Can anybody tell me that why we use option(*nodebugio)in H- Spec?

3 Answers  

---