TranNo

TranNo is a read-only built-in ispec attribute that is set to a number (in the range 000001 through 999999), that is incremented by one for each transaction that does not set Glb.Error to "*****" and is not in recovery. For MCP-based systems it is incremented for transactions that update the database or change the contents of Glb.Work. It is not incremented for inquiry transactions that do not modify Glb.Work.

It is used for both ispec and event transactions, but is included only in the event record on the database.

TranNo values are unique for each transaction sent from a station (username).

 Caution

Exercise care when using TranNo as a unique key in event records. It is possible for records from different stations to have the same TranNo value.

Properties

Length = 6

Primitive = Number