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
- 2 Answers
- 9086 Views
- TCS, I also Faced
- E-Mail Answers
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
| Is This Answer Correct ? | 8 Yes | 5 No |
Post New Answer View All Answers
Give a brief description of db2 isolation levels?
What does db2 blu stand for?
List out the data types available.
What is a db2 tablespace?
What is data manager?
What is a page in db2?
Before you give the explain statement, what are the prerogatives?
What is a db2 collection?
How can the duplicate values be eliminated from db2 select?
Explain how can you do the explain of a dynamic sql statement?
Which are the db2 tools to protect integrity of the database?
What is cursor with hold option in db2?
What is a db2 package?
What is a buffer in memory?
How do I create a view in db2?
