db2_autocommit

(PECL ibm_db2 >= 1.0.0)

db2_autocommit Returns or sets the AUTOCOMMIT state for a database connection

Descrierea

db2_autocommit ( resource $connection , bool $value = ? ) : mixed

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 întoarse

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 DB2_AUTOCOMMIT_OFF indicates that AUTOCOMMIT is off, while a value of DB2_AUTOCOMMIT_ON 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 == DB2_AUTOCOMMIT_OFF) {
    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_OFF);
$conn db2_connect($database$user$password$options);

// Turn AUTOCOMMIT on
$rc db2_autocommit($connDB2_AUTOCOMMIT_ON);
if (
$rc) {
    print 
"Turning AUTOCOMMIT on succeeded.\n";
}

// Check AUTOCOMMIT state
$ac db2_autocommit($conn);
if (
$ac == DB2_AUTOCOMMIT_OFF) {
    print 
"$ac -- AUTOCOMMIT is off.";
} else {
    print 
"$ac -- AUTOCOMMIT is on.";
}
?>

Exemplul de mai sus va afișa:

Turning AUTOCOMMIT on succeeded.
1 -- AUTOCOMMIT is on.

A se vedea și

add a note add a note

User Contributed Notes

There are no user contributed notes for this page.
To Top