PHP 8.3.21 Released!

    db2_stmt_error

    (PECL ibm_db2 >= 1.0.0)

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

    Description

    db2_stmt_error(?resource $stmt = null): string

    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(), the driver returns the SQLSTATE value associated with the last attempt to return a statement resource, for example, from db2_prepare() or db2_exec().

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

    Parameters

    stmt

    A valid statement resource.

    Return Values

    Returns a string containing an SQLSTATE value.

    See Also

    • db2_conn_error() - Returns a string containing the SQLSTATE returned by the last connection attempt
    • db2_conn_errormsg() - Returns the last connection error message and SQLCODE value
    • db2_stmt_errormsg() - Returns a string containing the last SQL statement error message

    Found A Problem?

    Learn How To Improve This Page • Submit a Pull Request • Report a Bug
    ＋add a note

    User Contributed Notes

    There are no user contributed notes for this page.
    To Top

    Follow Lee on X/Twitter - Father, Husband, Serial builder creating AI, crypto, games & web tools. We are friends :) AI Will Come To Life!

    Check out: eBank.nz (Art Generator) | Netwrck.com (AI Tools) | Text-Generator.io (AI API) | BitBank.nz (Crypto AI) | ReadingTime (Kids Reading) | RewordGame | BigMultiplayerChess | WebFiddle | How.nz | Helix AI Assistant