I am updating the data upto 1,00,000 at a point of 97653 the system crash happen ,i am trying to rollback the transaction
the records not get reflected to the database & buffer screen ,can anyone help on it,if possible ,please let me send the code
1,000,000? that's a huge transaction, some procedure I designed wrong some time ago, run out of resources near 5,000 records processed, in any case this is in theory what you should be doing:
(the trick is the do transaction to widen your scope to catch all the process in one transaction, and the handling of roll back will be handled by database itself, transparently to you)..
DO TRANSACTION:
FOR EACH (onemillionrecords query):
... do_something_to_record.....
END.
END.
Thanking you Octavio,
for your kind information if any suggestion ,please give me
For consistency, here is my response to your question on ProgressTalk:
Be aware that large transaction is generally bad practise. You want your transactions to be tight and quick. If you're updating a lot of information with a chance the transaction might roll back then obviously the system has to keep a track of this. Your BI will grow, and you'll probably run into lock table overflows.
An all or nothing approach like you describe needs some very careful thought and should only be used where absolutely necessary.