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)