![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
The types of accesses that your transaction makes to your data and the mode in which your transaction operates determine the types and levels of locks that are taken on the tables you are accessing. Locks on data are taken only if the transaction is operating in update mode. Locks on table definitions are always taken, regardless of mode.
Locking behavior can also be modified using the WITH MINLOCK modifier for the GET statement in the rules language. For details, see GET Statement.
The definition of the table cannot be modified but other transactions operating in update mode can read the data. The definition of the table cannot be modified and other transactions cannot read or modify the data.You can use the LOCKFAIL exception to handle situations where you are unable to obtain a lock. For example, the transaction can require an exclusive lock but another transaction is holding a shared lock. Refer to Chapter 6, Exception Handling for more information about exceptions.
Mode of Transaction Type of Lock GET or FORALL using unique (that is, equality) selection on the primary key fields, for example: GET or FORALL using non-unique selection, for example: Table instance (if parameterized). GET using non-unique Selection and WITH MINLOCK, for example:FORALL EMPLOYEES WHERE SALARY<100000 WITH MINLOCK: If parameterized: Table instance during GET processing, Occurrence thereafter.If non-parameterized: Table during GET processing, Occurrence thereafter. Upgrade shared to exclusive Browse and/or update Table instance (if parameterized). Browsing a CLC (calculation) table (read access on the underlying table) Source table instance (if parameterized). Accessing a SUB (subview) table defined with MODE=D Table instance (if parameterized). Accessing a SUB (subview) table defined with MODE=B TIBCO Service Gateway manuals about table locking as it relates to external databases.TIBCO Object Service Broker Managing Data about TIBCO Object Service Broker tables and table types.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |