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

Explain the contention situations caused by locks?

1070

---

What happens in bind step in a db2 program?

974

---

What is a dbrm in db2?

1021

---

What is the physical storage length of time data type?

1129

---

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2331

---

What does a deadlock mean in DB2?

1168

---

What's The Percentage Free Space ?

1224

---

What is rebind in db2?

1066

---

How to view db2 table structure?

1018

---

What is meant by explain?

1133

---

What is temporal table in db2?

1041

---

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1061

---

Before you give the explain statement, what are the prerogatives?

1040

---

Highlight all the advantages that are attached to a package.

1119

---

What is a bind card?

1217

---