Answer Posted / abhijit18in2002

when we are tying to update a table having 100 rows.
if the program abends when updating 51 row . how to start
updating again from the 51 row .
what was the logic


Ans: The Possible answer would be..if you had used COMMIT
before 51st ROW .. the Former records
would have been updated in the table .. If No COMMIt was
used.. The whole transaction would have been
ROLLBACKED.

Now If you want to start a fresh Transaction and want to
start Updating directly from 51st Row
Then There are two ways

1> Perform a loop to scroll till u have read 50 rows
Then Point ur cursor as CURRENT to the 51st Row
Start Updating the Records Till end of table.

or

2> Declare a Scrollable cursor & use FETCH ABSOLUTE option
to fetch a particular row directly


EXEC SQL FETCH ABSOLUTE +51 C1
INTO :TEMP1, :TEMP2, :TEMP3;


this statement fetches the 51st row of the Table

What are host variables in db2?

991

---

What does db2 stand for?

959

---

Explain about rct in db2?

1044

---

What is declare cursor?

1043

---

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

8133

---

What is runstats utility in db2?

962

---

Can one database have multiple instances?

1006

---

When reorg is used?

1071

---

Explain package in db2 and its advantages?

1134

---

Which components manage deadlocks in db2?

1016

---

Which component is responsible for db2 startup and shutdown?

981

---

What is the difference between drop table and delete table?

1117

---

Is the primary key a clustered index?

1078

---

What is db2 instance?

1016

---

Can there be more than one cursor open for any program?

1123

---