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

How to execute stored procedure in db2 command editor?

1053

---

What is host variable?

1065

---

what is the responsibility of the construction superintendent

2151

---

How do I add a column to an existing table in db2?

1037

---

What is meant by dclgen?

1119

---

What are db2 objects?

1054

---

What is the role of data manager in the db2 database?

1112

---

What is coalesce in db2?

1143

---

What is the difference between db2 and oracle?

1137

---

What are the full forms of spufi and dclgen and why are they used?

1094

---

What is the syntax for FETCH in DB2 ?

1225

---

Mention the various locks that are available in db2.

1050

---

How to check table size in db2 sap?

1048

---

Are views updateable?

1168

---

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

2073

---