db2_autocommit
(PECL ibm_db2:1.0-1.6.2)
db2_autocommit — Returns or sets the AUTOCOMMIT state for a database connection
Descrierea
Sets or gets the AUTOCOMMIT behavior of the specified connection resource.
Parametri
- connection
-
A valid database connection resource variable as returned from db2_connect() or db2_pconnect().
- value
-
One of the following constants:
- DB2_AUTOCOMMIT_OFF
-
Turns AUTOCOMMIT off.
- DB2_AUTOCOMMIT_ON
-
Turns AUTOCOMMIT on.
Valorile întroarse
When db2_autocommit() receives only the connection parameter, it returns the current state of AUTOCOMMIT for the requested connection as an integer value. A value of 0 indicates that AUTOCOMMIT is off, while a value of 1 indicates that AUTOCOMMIT is on.
When db2_autocommit() receives both the connection parameter and autocommit parameter, it attempts to set the AUTOCOMMIT state of the requested connection to the corresponding state. Întoarce valoarea TRUE în cazul succesului sau FALSE în cazul eşecului.
Exemple
Example#1 Retrieving the AUTOCOMMIT value for a connection
In the following example, a connection which has been created with AUTOCOMMIT turned off is tested with the db2_autocommit() function.
<?php
$options = array('autocommit' => DB2_AUTOCOMMIT_OFF);
$conn = db2_connect($database, $user, $password, $options);
$ac = db2_autocommit($conn);
if ($ac == 0) {
print "$ac -- AUTOCOMMIT is off.";
} else {
print "$ac -- AUTOCOMMIT is on.";
}
?>
Exemplul de mai sus va afişa:
0 -- AUTOCOMMIT is off.
Example#2 Setting the AUTOCOMMIT value for a connection
In the following example, a connection which was initially created with AUTOCOMMIT turned off has its behavior changed to turn AUTOCOMMIT on.
<?php
$options = array('autocommit' => DB2_AUTOCOMMIT_OF