RDOHELP72.HLB  —  SHOW  TRANSACTION
  (B)0SHOW TRANSACTION qqq>

    Displays information about the transaction mode, transaction id
    (TID), transaction sequence number (TSN), and, for read/write
    transactions, the status of updates and the full recovery-unit
    journal (RUJ) file specification. The SHOW TRANSACTION statement
    also shows whether or not fast commit is enabled.

    You must have the Oracle Rdb READ privilege for a database to use
    the SHOW TRANSACTION statement.

    The following START_TRANSACTION statement starts a read/write
    transaction reserving the EMPLOYEES table for shared read. Note
    that the SHOW TRANSACTION statement shows that fast commit is
    enabled for the database.

    RDO> START_TRANSACTION READ_WRITE RESERVING
    cont> EMPLOYEES FOR SHARED READ
    RDO> SHOW TRANSACTION
    All Transactions in Database with filename MF_PERSONNEL
    a read-write transaction is in progress
      - updates have not been performed
      - fast commit is enabled
      - transaction sequence number (TSN) is 121
      - snapshot space for TSNs less than 121 can be reclaimed
      - session ID number is 42
Close Help