Transaction Tracking

The following field parameters in the SQT block display information that can help you in debugging your setup or help monitor real-time transactions:

  • A_SEQ displays a transaction number indicating that the block has recognized an event. Transaction numbers increment from 1 to 255.
  • A_XTIME displays the time of the last transaction.
  • A_XDATE displays the date of the last transaction.
  • A_STATE displays the current operating state of each SQT block.
  • A_DBERR displays the native database error number of the last SQL command executed.
  • A_SQLST displays the SQL state of the last SQL command executed.