Results 1 to 2 of 2

Thread: explicit commit

  1. #1
    Join Date
    Jan 2003
    Posts
    1

    Lightbulb Unanswered: explicit commit

    When I enter a SQL, say UPDATE, statement from CLI, it is always auto-committed. Is there a way that I can make it NOT auto-commit? Means, I have to explicitly enter a COMMIT statement after the UPDATE.


    Thanks much.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: explicit commit

    Method 1:
    db2 list command options
    db2 update command options

    Method 2:
    Make an entry in the db2cli.ini to turn off autocommit for all connections using the alias

    Method3:
    db2 +c "update ...."

    If I wanted the facility temperorily I use Method 3 . If the application requires it I use Method 2...

    HTH
    Cheers

    Sathyaram


    Originally posted by JimYoung
    When I enter a SQL, say UPDATE, statement from CLI, it is always auto-committed. Is there a way that I can make it NOT auto-commit? Means, I have to explicitly enter a COMMIT statement after the UPDATE.


    Thanks much.

Posting Permissions

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