PHP  
downloads | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | my php.net 
search for in the  
<ibm_db2db2_bind_param>
Last updated: Mon, 16 Jul 2012

db2_autocommit

(no version information, might be only in CVS)

db2_autocommit --  Returns or sets the AUTOCOMMIT state for a database connection

说明

mixed db2_autocommit ( resource connection [, bool value] )

警告

本函数是实验性的。本函数的行为,包括函数名称以及其它任何关于本函数的文档可能会在没有通知的情况下随 PHP 以后的发布而改变。使用本函数风险自担。

Sets or gets the AUTOCOMMIT behavior of the specified connection resource.

参数

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.

返回值

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. 如果成功则返回 TRUE,失败则返回 FALSE

例子 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.";
}
?>

上例将输出:

0 -- AUTOCOMMIT is off.

例子 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($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.";
}
?>

上例将输出:

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

参见

db2_connect()
db2_pconnect()
db2_setoption()




<ibm_db2db2_bind_param>
 Last updated: Mon, 16 Jul 2012
 
Copyright © 2001-2005 The PHP Group
All rights reserved.
This unofficial mirror is operated at: http://manual.phpv.net/
Last updated: Thu Jul 7 19:13:47 2005 CST