Topic
  • 1 reply
  • Latest Post - ‏2013-07-31T17:10:32Z by kevintap
asian123
asian123
46 Posts

Pinned topic Update Query with Return Results and Rollback functionality

‏2013-07-31T10:56:42Z |

Hi ,

I have to update large data row -by-row , in between if any point of time if any row is not updating , entire previous updated data from the database has to rollback.

how i can check that the row is updated or not ?

i have checked the box of 'Retrieve Update Results'  in SQL Call Builder and it will give me one variable like builderNameLastUpdateCount , but when it is giving me null always..so that i am not able to see wether it is updated or not..

Asian123

  • kevintap
    kevintap
    752 Posts

    Re: Update Query with Return Results and Rollback functionality

    ‏2013-07-31T17:10:32Z  

    Are you using the SQL Transaction builder here?  My recommendation would be to add constraints to your database which would trigger an exception in the case of a failed update.  If you're using the SQL Transaction builder, you can then rollback the entire transaction in response to receiving a SQL exception.

    The postings on this site are my own and do not necessarily represent the positions, strategies, or opinions of IBM.