db2_autocommit(3) [php man page]

DB2_AUTOCOMMIT(3)							 1							 DB2_AUTOCOMMIT(3)

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

SYNOPSIS

       mixed db2_autocommit (resource  $connection, [bool  $value])

DESCRIPTION

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

PARAMETERS

	      o $connection
		- A valid database connection resource variable as returned from db2_connect(3) or db2_pconnect(3).

	      o $value
		- One of the following constants:

		     o DB2_AUTOCOMMIT_OFF - Turns AUTOCOMMIT off.

		     o DB2_AUTOCOMMIT_ON - Turns AUTOCOMMIT on.

RETURN VALUES

	When db2_autocommit(3) 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(3) 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.

EXAMPLES

       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(3) func-
	      tion.

	      <?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:

	      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($conn, DB2_AUTOCOMMIT_ON);
	      if ($rc) {
		  print "Turning AUTOCOMMIT on succeeded.
";
	      }

	      // 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:

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

SEE ALSO

       db2_connect(3), db2_pconnect(3).

PHP Documentation Group 													 DB2_AUTOCOMMIT(3)

Check Out this Related Man Page

DB2_CONN_ERRORMSG(3)							 1						      DB2_CONN_ERRORMSG(3)

db2_conn_errormsg - Returns the last connection error message and SQLCODE value

SYNOPSIS

       string db2_conn_errormsg ([resource  $connection])

DESCRIPTION

       db2_conn_errormsg(3)  returns  an  error  message and SQLCODE value representing the reason the last database connection attempt failed. As
       db2_connect(3) returns FALSE in the event of a failed connection attempt, do not pass any parameters to	db2_conn_errormsg(3)  to  retrieve
       the associated error message and SQLCODE value.

	If,  however,  the connection was successful but becomes invalid over time, you can pass the $connection parameter to retrieve the associ-
       ated error message and SQLCODE value for a specific connection.

PARAMETERS

	      o $connection
		- A connection resource associated with a connection that initially succeeded, but which over time became invalid.

RETURN VALUES

	Returns a string containing the error message and SQLCODE value resulting from a failed connection attempt. If there is no  error  associ-
       ated with the last connection attempt, db2_conn_errormsg(3) returns an empty string.

EXAMPLES

       Example #1

	      Retrieving the error message returned by a failed connection attempt

	       The  following  example demonstrates how to return an error message and SQLCODE value after deliberately passing invalid parameters
	      to db2_connect(3).

	      <?php
	      $conn = db2_connect('badname', 'baduser', 'badpassword');
	      if (!$conn) {
		  print db2_conn_errormsg();
	      }
	      ?>

	      The above example will output:

	      [IBM][CLI Driver] SQL1013N  The database alias name
	      or database name "BADNAME" could not be found.  SQLSTATE=42705
	       SQLCODE=-1013

SEE ALSO

       db2_conn_error(3), db2_connect(3), db2_stmt_error(3), db2_stmt_errormsg(3).

PHP Documentation Group 												      DB2_CONN_ERRORMSG(3)

Linux and UNIX Man Pages

db2_autocommit(3) [php man page]

Check Out this Related Man Page