Library /sys$common/syshlp/SQL$HELP_OLD72.HLB  —  GET_DIAGNOSTICS, Format
  GET DIAGNOSTICS -------------------------------------------+
  +----------------------------------------------------------+
  +-+-+-+-> <parameter> +---> = statement-item-name -----+-------------+>
    | | +-> <variable> -+                                |             |
    | +---------------- , <------------------------------+             |
    +-> EXCEPTION --> 1 -+-+-> <parameter> +> = statement-info-clause ++
                         | +-> <variable> -+                          |
                         +-------------------- , <--------------------+

  statement-item-name =

  ----+-> ACCESS_MODE -----------------+-->
      +-> CALLING_ROUTINE -------------+
      +-> CONNECTION_NAME -------------+
      +-> CURRENT_ROW -----------------+
      +-> DATABASE_HANDLE -------------+
      +-> GLOBAL_TRANSACTION ----------+
      +-> HOT_STANDBY_MODE ------------+
      +-> IMAGE_NAME  -----------------+
      +-> ISOLATION_LEVEL -------------+
      +-> LIMIT_CPU_TIME --------------+
      +-> LIMIT_ELAPSED_TIME ----------+
      +-> LIMIT_ROWS_FETCHED ----------+
      +-> ROW_COUNT -------------------+
      +-> SERVER_IDENTIFICATION -------+
      +-> TRACE_ENABLED ---------------+
      +-> TRANSACTION_ACTIVE ----------+
      +-> TRANSACTION_CHANGE_ALLOWED --+
      +-> TRANSACTION_SEQUENCE --------+
      +-> TRANSACTION_TIMESTAMP -------+

      +-> TRANSACTIONS_COMMITTED  -----+
      +-> TRANSACTIONS_ROLLED_BACK ----+

  statement-info-clause =

  -+-> RETURNED_SQLSTATE --+--->
   +-> RETURNED_SQLCODE ---+
Close Help