Results 1 to 3 of 3
  1. #1
    Join Date
    May 2011

    Unanswered: Smart Rollback occurred


    UPDATE seg_encounter_location_rate SET ward_nr='1', room_nr='15', bed_nr='1', rate='0.0000' WHERE encounter_nr='2009023671' AND loc_enc_nr='411265'

    I've got an error:
    No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table.

    What do you mean by Smart Rollback occurred?
    How can I resolve my error?

  2. #2
    Join Date
    Feb 2008
    I don't know what do you mean by "Smart Rollback".

    By the way, the error(?) said that No row was found which satisfy the WHERE condition encounter_nr='2009023671' AND loc_enc_nr='411265'.

    So, it would be a warning, not an error.

  3. #3
    Join Date
    Jan 2007
    Jena, Germany
    Maybe "Smart Rollback" just means the fact that all changes that the SQL statement would have made are undone in case the SQL statement fails (but not with a warning as is the case here). However, that's not a "rollback" but rather a way to guarantee that each statement is atomically executed.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts