IBM DB2, Cloudscape and Apache Derby Functionsdb2_autocommit
(PECL ibm_db2:1.0-1.5.1)
db2_autocommit — Returns or sets the AUTOCOMMIT state for a database connection
Popis
mixed db2_autocommit ( resource $connection [, bool $value] )Sets or gets the AUTOCOMMIT behavior of the specified connection resource.
Seznam parametrů
- 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.
Návratové hodnoty
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. Vrací TRUE při úspěchu, FALSE při selhání.
Příklady
Příklad 703. 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.";
}
?>
Výše uvedený příklad vypíše:
0 -- AUTOCOMMIT is off.
Příklad 704. 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_OFF);
$conn = db2_connect($database, $user, $password, $options);
// Turn AUTOCOMMIT on
$rc = db2_autocommit($conn, DB2_AUTOCOMMIT_ON);
if ($rc) {
print "Turning AUTOCOMMIT on succeeded.\n";
}
// Check AUTOCOMMIT state
$ac = db2_autocommit($conn);
if ($ac == 0) {
print "$ac -- AUTOCOMMIT is off.";
} else {
print "$ac -- AUTOCOMMIT is on.";
}
?>
Výše uvedený příklad vypíše:
Turning AUTOCOMMIT on succeeded.
1 -- AUTOCOMMIT is on.
Viz také
| db2_connect() |
| db2_pconnect() |
add a note
User Contributed Notesdb2_autocommit