db2_close(3) [php man page]

DB2_CLOSE(3)								 1							      DB2_CLOSE(3)

db2_close - Closes a database connection

SYNOPSIS

       bool db2_close (resource  $connection)

DESCRIPTION

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

	If  you  attempt to close a persistent DB2 client connection created with db2_pconnect(3), the close request is ignored and the persistent
       DB2 client connection remains available for the next caller.

PARAMETERS

	      o $connection
		- Specifies an active DB2 client connection.

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      Closing a connection

	       The following example demonstrates a successful attempt to close a connection to an IBM DB2, Cloudscape, or Apache Derby database.

	      <?php
	      $conn = db2_connect('SAMPLE', 'db2inst1', 'ibmdb2');
	      $rc = db2_close($conn);
	      if ($rc) {
		  echo "Connection was successfully closed.";
	      }
	      ?>

	      The above example will output:

	      Connection was successfully closed.

SEE ALSO

       db2_connect(3), db2_pclose(3), db2_pconnect(3).

PHP Documentation Group 													      DB2_CLOSE(3)

DB2_CONN_ERROR(3)							 1							 DB2_CONN_ERROR(3)

db2_conn_error - Returns a string containing the SQLSTATE returned by the last connection attempt

SYNOPSIS

       string db2_conn_error ([resource  $connection])

DESCRIPTION

       db2_conn_error(3)  returns  an  SQLSTATE  value representing the reason the last attempt to connect to a database failed. As db2_connect(3)
       returns FALSE in the event of a failed connection attempt, you do not pass any parameters to db2_conn_error(3)  to  retrieve  the  SQLSTATE
       value.

	If,  however, the connection was successful but becomes invalid over time, you can pass the $connection parameter to retrieve the SQLSTATE
       value for a specific connection.

	To learn what the SQLSTATE value means, you can issue the following command at a DB2 Command Line  Processor  prompt:  db2  '?	$sqlstate-
       value'. You can also call db2_conn_errormsg(3) to retrieve an explicit error message and the associated SQLCODE value.

PARAMETERS

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

RETURN VALUES

	Returns  the  SQLSTATE	value resulting from a failed connection attempt. Returns an empty string if there is no error associated with the
       last connection attempt.

EXAMPLES

       Example #1

	      Retrieving an SQLSTATE value for a failed connection attempt

	       The following example demonstrates how to return an SQLSTATE value after deliberately passing invalid parameters to db2_connect(3).

	      <?php
	      $conn = db2_connect('badname', 'baduser', 'badpassword');
	      if (!$conn) {
		  print "SQLSTATE value: " . db2_conn_error();
	      }
	      ?>

	      The above example will output:

	      SQLSTATE value: 08001

SEE ALSO

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

PHP Documentation Group 													 DB2_CONN_ERROR(3)