Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    2

    Unanswered: how i can commit curren 1 row only?

    on db2(os390 7.1.1)
    in my transcation i operate n table (update ,insert ),if i find a logic error
    and i want to rollback all this operate,but i want to write a log recorder to my log table for error information and just commit this work . on db2(as400) i can use insert with nc,but i can use this on db2(os390).

    how i can do ?
    thanks!

  2. #2
    Join Date
    Nov 2003
    Location
    Germany
    Posts
    62
    You can first do your rollback, then insert your log record and then commit.

Posting Permissions

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