2 Replies Latest reply: Aug 27, 2012 10:18 PM by user6258915 RSS

    How to change Default setting AutoCommit to 0 in Procedure or in Connecting

    user6258915
      [tttest@host1 ~]$ ttisql "dsn=ana_tt1122"

      Copyright (c) 1996-2011, Oracle. All rights reserved.
      Type ? or "help" for help, type "exit" to quit ttIsql.



      connect "dsn=ana_tt1122";

      Warning 20000: Use of a deprecated feature: Authenticate (ignored)

      Connection successful: DSN=ana_tt1122;UID=tttest;DataStore=/timesten/TimesTen/tt1122/info/ana/ana;DatabaseCharacterSet=ZHS16GBK;ConnectionCharacterSet=ZHS16GBK;DRIVER=/timesten/TimesTen/tt1122/lib/libtten.so;OracleId=ABCD;PermSize=1200;TempSize=500;TypeMode=0;OracleNetServiceName=ABCD;
      (Default setting AutoCommit=1)

      The "Default setting AutoCommit=1",I can modify it only later using :
      Command> autocommit 0;

      But, I want to know: Can I set the "Default setting AutoCommit=0"? When I connect the DSN? or Can I set "Default setting AutoCommit=0" in a procedure ? Because sometime I maybe want to change it in procedure.


      Thanks very.