Release Notes
|
|
|
|
|
|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.
|
|
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]