Answer / jagan

using select in embedded sql with where clause should fetch
only one row , but cursor can be used when we need more rows
to be retrieved one at a time.

In case more than one row is retrieved in a select clause it
will throw -811 sql error.

Answer / vinay srivastava

Normal select Query fetches all rows in one go while cursor
fetches one row at a time.

I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).

10 Answers   Cap Gemini, Wipro,

---

In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?

1 Answers  

---

What are the contents of dclgen?

0 Answers  

---

Bind concepts in DB2 cobol

10 Answers   IBM, TCS, TRD, Virtusa,

---

pls explain the precompilation process of cobol-db2 pgm

3 Answers   HCL, IBM,

---

What is a lock?

1 Answers  

---

What is the maximum number of tables that can be stored on a Partitioned Table Space ?

1 Answers   IBM,

---

I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?

2 Answers  

---

What is ALTER ?

3 Answers  

---

What does db2 mean?

0 Answers  

---

what is cursor stability?

2 Answers   IBM,

---

how to execute qcmdexc in rpgle?plz write code also?

1 Answers   IBM,

---