db2_pclose(3) [php man page]

DB2_PCLOSE(3)								 1							     DB2_PCLOSE(3)

db2_pclose - Closes a persistent database connection

SYNOPSIS

       bool db2_pclose (resource  $resource)

DESCRIPTION

	This function closes a DB2 client connection created with db2_pconnect(3) and returns the corresponding resources to the database server.

       Note

	       This function is only available on i5/OS in response to i5/OS system administration requests.

	If  you  have a persistent DB2 client connection created with db2_pconnect(3), you may use this function to close the connection. To avoid
       substantial connection performance penalties, this function should only be used in rare cases when the  persistent  connection  has  become
       unresponsive or the persistent connection will not be needed for a long period of time.

PARAMETERS

	      o $connection
		- Specifies an active DB2 client connection.

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      Closing a persistent connection

	       The following example demonstrates a successful attempt to close a connection to an IBM DB2 i5/OS database.

	      <?php
	      $conn = db2_pconnect('', '', '');
	      $rc = db2_pclose($conn);
	      if ($rc) {
		  echo "Connection was successfully closed.";
	      }
	      ?>

	      The above example will output:

	      Connection was successfully closed.

SEE ALSO

       db2_close(3), db2_pconnect(3).

PHP Documentation Group 													     DB2_PCLOSE(3)

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)