Release Notes

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

|