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