Library /sys$common/syshlp/SQL$HELP_OLD72.HLB  —  GET_DIAGNOSTICS
    Extracts diagnostic information about the execution of the
    previous SQL statement or SQL routine environment.

    The GET DIAGNOSTICS statement captures diagnostic information
    from an Oracle Rdb maintained data structure called the
    diagnostics area. In the ANSI/ISO SQL standard, the diagnostics
    area consists of two components: a single header area and an
    array of detail areas. Oracle Rdb extracts information only from
    the header component and the first element of the detail area
    (Exception 1):

    o  Header area

       Contains status information about rows and transactions, for
       example, the number of rows affected by an INSERT, UPDATE, or
       DELETE statement or the type of transaction that is active.

       See the statement-item-name argument for a complete list of
       the status information you can retrieve from the header area.

    o  Detail area (Exception 1)

       Contains diagnostic information that corresponds to the status
       that would be reported in the SQLSTATE or SQLCODE status
       parameter. The EXCEPTION . . . RETURNED_SQLSTATE argument
       retrieves the SQLSTATE status information from the detail
       area. The EXCEPTION . . . RETURNED_SQLCODE argument retrieves
       the SQLCODE status information from the detail area.
Additional Information: explode extract
Environment Format Arguments Examples
Close Help