AUTOCOMMIT v DBI default

[Jiri Kratochvil]

> Pouzivam BDI - ODBC pro pristup k BD na AS400 z NT stroju.

pouzivate DBI nebo ODBC?

dale predpokladam ze DBI.


> Dle BDI dokumentace je parametr autocomit pri otevreni nastaven na defautl hodnotu 
> Na jakou ?



$perldoc DBI
<cut>
            Drivers should always default to `AutoCommit' mode (an
            unfortunate choice largely forced on the DBI by ODBC
            and JDBC conventions.)
<\cut>
...
<cut>
            For the purposes of this description, we can divide
            databases into three categories:

              Databases which don't support transactions at all.
              Databases in which a transaction is always active.
              Databases in which a transaction must be explicitly 
started (C<'BEGIN WORK'>)
<\cut>

Myslim ze zbytkem standartni dokumentace dodavane k DBI je zbytecne plni 
t konferenci a zbytek si dohledate sam


> Drha otazka :
> Autocommit=>1 znamena co ? Ze po kzaden Insert se provede commit ?


Autocommit znamena ze po jakemkoliv volani databaze nasleduje COMMIT. 
cili pri volani "SELECT * FROM t_table;" probiha zhruba toto

BEGIN;
SELECT * FROM t_table;
COMMIT;


> Dik Za pomoc
> Lubos 
> EDINET
> 
> mailto:lubos.polednicek na edi.cz
> 
>   
> 
>