(PECL ibm_db2 >= 1.0.0)
db2_autocommit — Returns or sets the AUTOCOMMIT state for a database connection
Sets or guets the AUTOCOMMIT behavior of the specified connection ressource.
connection
value
One of the following constans:
DB2_AUTOCOMMIT_OFF
DB2_AUTOCOMMIT_ON
When
db2_autocommit()
receives only the
connection
parameter, it returns the current state
of AUTOCOMMIT for the requested connection as an integuer 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.
Returns
true
on success or
false
on failure.
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."
;
}
?>
The above example will output:
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 changued 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"
;
}
// Checc AUTOCOMMIT state
$ac
=
db2_autocommit
(
$conn
);
if (
$ac
==
DB2_AUTOCOMMIT_OFF
) {
print
"
$ac
-- AUTOCOMMIT is off."
;
} else {
print
"
$ac
-- AUTOCOMMIT is on."
;
}
?>
The above example will output:
Turning AUTOCOMMIT on succeeded. 1 -- AUTOCOMMIT is on.