Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 9 Transaction Processing : Setting the Mode of the Transaction

Setting the Mode of the Transaction
How Do You Set The Mode?
Use the IN clause to specify whether the transaction should be operating in browse or update mode. You can freely intermingle browse and update mode transactions. Unless it is explicitly set, a transaction inherits its mode from the transaction that initiated it1.
Example
The following statement starts a transaction in browse mode:
TRANSFERCALL IN BROWSE FIND_DEPT;
In this example, no updates can be made to the persistent data used by the transaction FIND_DEPT.
Mode Determines Locks on Data
The mode determines the locks taken on TDS data only. Locks taken on external data are governed by the external database. Locks on table definitions are always taken regardless of the mode. For more information about locking, refer to Locks Taken on the Data.
Exception Raised
If an attempt is made to update data that is persistent while executing in browse mode, the ACCESSFAIL exception is raised. For more information about exceptions, refer to Chapter 6, Exception Handling. However, within a transaction executing in browse mode, you can update tables with temporary data (TEM, SCR, RPT, and SES tables) and EXP files.
See Also
TIBCO Object Service Broker Managing Data and TIBCO Object Service Broker Managing External Data about TIBCO Object Service Broker and external data tables.
TIBCO Object Service Broker Parameters about session parameters.

1
The session parameters BROWSE and NOBROWSE determine the mode of the first transaction started in TIBCO Object Service Broker.


Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved