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
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
What is difference between isnull and coalesce?
i want to maintain uniqueness on pdf without make lf??????????
What does db2 stand for?
What is dpf in db2?
What is a db2 cursor?
Explain package in db2 and its advantages?
When reorg is used?
How can deadlocks be resolved?
How can you do the explain of a dynamic sql statement?
What is the use of db2 optimizer?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
Where can you declare a cursor in a cobol-db2 program?
What is package in db2 mainframe?
How connect db2 database to datastage?
What is the usage of open cursor command?