db2_stmt_error

(PECL ibm_db2 >= 1.0.0)

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

说明

db2_stmt_error ([ resource $stmt ] ) : 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.

参数

stmt

A valid statement resource.

返回值

Returns a string containing an SQLSTATE value.

参见

  • 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

相关文章
php ibm db2 函数 binds a php variable to an sql statement parameterphp ibm db2 函数 returns a result set listing the columns and associated privileges for a tablephp ibm db2 函数 returns a result set listing the columns and associated metadata for a tablephp ibm db2 函数 returns a string containing the sqlstate returned by the last connection attemptphp ibm db2 函数 returns the last connection error message and sqlcode valuephp ibm db2 函数 returns the cursor type used by a statement resourcephp ibm db2 函数 executes an sql statement directlyphp ibm db2 函数 executes a prepared sql statementphp ibm db2 函数 returns the name of the column in the result setphp ibm db2 函数 returns the position of the named column in a result setphp ibm db2 函数 returns the precision of the indicated column in a result setphp ibm db2 函数 returns the scale of the indicated column in a result setphp ibm db2 函数 returns the data type of the indicated column in a result setphp ibm db2 函数 returns the number of rows affected by an sql statementphp ibm db2 函数 returns a persistent connection to a databasephp ibm db2 函数 prepares an sql statement to be executedphp ibm db2 函数 returns a result set listing primary keys for a tablephp ibm db2 函数 returns a result set listing stored procedure parametersphp ibm db2 函数 returns a string containing the sqlstate returned by an sql statementphp ibm db2 函数 returns a string containing the last sql statement error message
关注编程学问公众号