Displays the characteristics of the current transaction or, if
    there is no active transaction, the characteristics specified in
    the last DECLARE TRANSACTION statement. For each database within
    the scope of the transaction, SQL displays the following:

    o  Transaction

    o  Tables specified in the RESERVING clause of the DECLARE
       TRANSACTION or SET TRANSACTION statement

    o  Share mode and lock type for each of those tables

    o  If fast commit processing is enabled

    In addition, the SHOW TRANSACTION statement displays transaction
    information returned by the base database system about the
    transaction, such as whether or not the transaction is active.