db2_stmt_error(3) [php man page]

DB2_STMT_ERROR(3)							 1							 DB2_STMT_ERROR(3)

db2_stmt_error - Returns a string containing the SQLSTATE returned by an SQL statement

SYNOPSIS

       string db2_stmt_error ([resource  $stmt])

DESCRIPTION

	Returns a string containing the SQLSTATE value returned by an SQL statement.

	If  you  do  not  pass a statement resource as an argument to db2_stmt_error(3), the driver returns the SQLSTATE value associated with the
       last attempt to return a statement resource, for example, from db2_prepare(3) or db2_exec(3).

	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_stmt_errormsg(3) to retrieve an explicit error message and the associated SQLCODE value.

PARAMETERS

	      o $stmt
		- A valid statement resource.

RETURN VALUES

	Returns a string containing an SQLSTATE value.

SEE ALSO

       db2_conn_error(3), db2_conn_errormsg(3), db2_stmt_errormsg(3).

PHP Documentation Group 													 DB2_STMT_ERROR(3)

INGRES_ERRSQLSTATE(3)							 1						     INGRES_ERRSQLSTATE(3)

ingres_errsqlstate - Get the last SQLSTATE error code generated

SYNOPSIS

       string ingres_errsqlstate ([resource  $link])

DESCRIPTION

	Returns a string containing the last SQLSTATE, or NULL if no error has occurred.

	If  a  $link  resource	is  passed  to	ingres_errsqlstate(3), it returns the last error recorded for the link. If no link is passed, then
       ingres_errsqlstate(3) returns the last error reported using the default link.

	The function, ingres_errsqlstate(3), should always be  called  after  executing  any  database	query.	Calling  another  function  before
       ingres_errsqlstate(3) is called will reset or change any error message from the last Ingres function call.

PARAMETERS

	      o $link
		- The connection link identifier

RETURN VALUES

	Returns a string containing the last SQLSTATE, or NULL if no error has occurred.

EXAMPLES

       Example #1

	      Get the last SQLSTATE error code generated

	      <?php
	      $link = ingres_connect($database, $user, $password);

	      $result = ingres_query($link, "select * from table");

	      $error_sqlstate = ingres_errsqlstate($link);

	      if (!is_null($error_sqlstate)) {
		 echo "An error occurred - " . $error_sqlstate;
	      }
	      ?>

SEE ALSO

       ingres_errno(3), ingres_error(3), ingres_next_error(3).

PHP Documentation Group 												     INGRES_ERRSQLSTATE(3)