db2_conn_errormsg

db2_conn_errormsg

Returns the last connection error message and SQLCODE value

string **db2_conn_errormsg**  $connection

returns an error message and SQLCODE

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

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

connectionA connection resource associated with a connection that initially succeeded, but which over time became invalid.

Returns a string containing the error message and SQLCODE value resulting from a failed connection attempt. If there is no error associated with the last connection attempt, returns an empty string. db2_conn_errormsg

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

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

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

db2_conn_error``db2_connect``db2_stmt_error``db2_stmt_errormsg