en:app:020cor:020abw:0190tro

TRO - Transaction Dependencies

Module TRO

This table holds dependencies between different transactions and thus defines the order in which transactions are to be released.

This table is created with two different purposes.

1. It is used to determine, whether the data of a contract is currently in a non guaranteed status, as a modifying transaction is not yet released. Based on this table a warning message on start of a transaction could be created, if contract data modifying transactions are not yet released.

2. It is used to automatically roll back transactions, which are based on contract data, where the modifying transactions are rolled back.


Datafields

Name Helptext Description Data Type Len Codetable
INR Internal Unique ID Text 8
TRNINR INR of Contract Changing Transaction Text 8
PRVINR INR of Preceding Transaction Text 8
OBJTYP Object Type Text 6
OBJINR Object INR Text 8
LSTFLG Flag to Mark Last TRO for Contract Text 1 Embedded

Datafield Description and Properties


Datafield INR Internal Unique ID

Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter of this table. The field INR is used to enable links from other tables to this table.

For contractdata the INR also links the two tables xxD and xxT as associated entries hold the same INR.


Datafield TRNINR INR of Contract Changing Transaction

Unique ID of the transaction that created or processed the contract.


Datafield PRVINR INR of Preceding Transaction

This field holds the transaction ID of the preceding transaction that is dependent on the same contract.


Datafield OBJTYP Object Type

Object type of the holing contract. (e.g. LID, GID). Used together with the internal unique ID of the object.


Datafield OBJINR Object INR

The unique ID of the holding contract; used together with the Object Type field.


Datafield LSTFLG Flag to Mark Last TRO for Contract

The most recently added transaction is marked with an 'X' to identify those entries where new dependencies have to be linked.

Codetable
Code Text
R Transaction TRNINR was rejected
X Transaction TRNINR is last open TRN for OBJTYP/OBJINR
D Transaction TRNINR has been committed and cannot be rolled back
Normal entry
en/app/020cor/020abw/0190tro.txt · Last modified: 2024/01/10 16:23 by dm