Results 1 to 4 of 4

Thread: auto commit

  1. #1
    Join Date
    Mar 2003
    Location
    India
    Posts
    10

    Unanswered: auto commit

    hi,

    How should i set the auto commit off in db2 version 7 installed on linux 6.2?? thanx for help in advance.

    Take care
    Vinu

  2. #2
    Join Date
    Jan 2003
    Posts
    17
    if you are using ODBC just like this in your program:

    SQLSetConnectOption(myHdbc, SQL_AUTOCOMMIT, SQL_AUTOCOMMIT_OFF);

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

    Re: auto commit

    Or you can set AUTOCOMMIT to off in the db2cli.ini file if all connections 'via' that alias will be using autocommit as off ...

    Cheers

    Sathyaram

    Originally posted by Vinu Pillai
    hi,

    How should i set the auto commit off in db2 version 7 installed on linux 6.2?? thanx for help in advance.

    Take care
    Vinu

  4. #4
    Join Date
    Jan 2003
    Posts
    1,605

    Re: auto commit

    Hi,

    Read the link http://dbforums.com/t687978.html

    Hope this helps,
    Grofaty

Posting Permissions

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