版本注意事項

|42.7 Additional Options in the GET DIAGNOSTICS Statement

|GET DIAGNOSTICS Statement

|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. |

|