版本注意事項
|
|
|
|
|
|The GET DIAGNOSTICS statement is used to obtain information about the previously
|executed SQL statement. The syntax of this statement has been updated as follows.
|Command Syntax
|>>-GET DIAGNOSTICS---------------------------------------------->
|
|>--+-SQL-variable-name--=--+-ROW_COUNT-----+-+-----------------><
| | '-RETURN_STATUS-' |
| '-| condition-information |---------------'
|
|condition-information
|
||--EXCEPTION--1------------------------------------------------->
|
| .-,------------------------------------------.
| V |
|>----SQL-variable-name--=--+-MESSAGE_TEXT-----+-+---------------|
| '-DB2_TOKEN_STRING-'
|
|
|Command Parameters
|
- |SQL-variable-name
- |Identifies the variable that is the assignment target. If ROW_COUNT
|or RETURN_STATUS is specified, the variable must be an integer variable. Otherwise,
|the variable must be CHAR or VARCHAR. SQL variables can be defined in a compound
|statement.
- |ROW_COUNT
- |Identifies the number of rows associated with the previous SQL statement.
|If the previous SQL statement is a DELETE, INSERT, or UPDATE statement, ROW_COUNT
|identifies the number of rows deleted, inserted, or updated by that statement,
|excluding rows affected by triggers or referential integrity constraints.
|If the previous statement is a PREPARE statement, ROW_COUNT identifies the estimated number of result rows in the prepared statement.
- |RETURN_STATUS
- |Identifies the status value returned from the stored procedure associated
|with the previously executed SQL statement, provided that the statement was
|a CALL statement invoking a procedure that returns a status. If the previous
|statement is not such a statement, then the value returned has no meaning
|and could be any integer.
- |condition-information
- |Specifies that the error or warning information for the previously executed
|SQL statement is to be returned. If information about an error is needed,
|the GET DIAGNOSTICS statement must be the first statement specified in the
|handler that will handle the error. If information about a warning is needed,
|and if the handler will get control of the warning condition, the GET DIAGNOSTICS
|statement must be the first statement specified in that handler. If the handler
|will not get control of the warning condition,
|the GET DIAGNOSTICS statement must be the next statement executed.
|
- |MESSAGE_TEXT
- |Identifies any error or warning message text returned from the previously
|executed SQL statement. The message text is returned in the language of the
|database server where the statement is processed. If the statement completes
|with an SQLCODE of zero, an empty string or blanks are returned.
- |DB2_TOKEN_STRING
- |Identifies any error or warning message tokens returned from the previously
|executed SQL statement. If the statement completes with an SQLCODE of zero,
|or if the SQLCODE has no tokens, then an empty string or blanks is returned.
|
|
[ 頁面頂端 | 前一頁 | 下一頁 | 目錄 | 索引 ]