db2_autocommit

Returns or sets the AUTOCOMMIT state for a database connection (PECL ibm_db2:1.0-1.6.2)
mixed db2_autocommit ( resource connection [, bool value] )

Example 911. 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.

copy to clipboard

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

}
?>

The above example will output:

copy to clipboard

0 -- AUTOCOMMIT is off.

Example 912. 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.

copy to clipboard

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

}
?>

The above example will output:

copy to clipboard

Turning AUTOCOMMIT on succeeded.

1 -- AUTOCOMMIT is on.

Change Language

db2_autocommit
db2_bind_param
db2_client_info
db2_close
db2_column_privileges
db2_columns
db2_commit
db2_conn_error
db2_conn_errormsg
db2_connect
db2_cursor_type
db2_escape_string
db2_exec
db2_execute
db2_fetch_array
db2_fetch_assoc
db2_fetch_both
db2_fetch_object
db2_fetch_row
db2_field_display_size
db2_field_name
db2_field_num
db2_field_precision
db2_field_scale
db2_field_type
db2_field_width
db2_foreign_keys
db2_free_result
db2_free_stmt
db2_get_option
db2_lob_read
db2_next_result
db2_num_fields
db2_num_rows
db2_pconnect
db2_prepare
db2_primary_keys
db2_procedure_columns
db2_procedures
db2_result
db2_rollback
db2_server_info
db2_set_option
db2_special_columns
db2_statistics
db2_stmt_error
db2_stmt_errormsg
db2_table_privileges
db2_tables

db2_autocommit

Returns or sets the AUTOCOMMIT state for a database connection (PECL ibm_db2:1.0-1.6.2) mixed db2_autocommit ( resource connection [, bool value] )

Example 911. Retrieving the AUTOCOMMIT value for a connection

Example 912. Setting the AUTOCOMMIT value for a connection

Change Language

Returns or sets the AUTOCOMMIT state for a database connection (PECL ibm_db2:1.0-1.6.2)
mixed db2_autocommit ( resource connection [, bool value] )