Restrictions

You can only modify one type of data in a transaction. That is, you can do the following within the same transaction:

You cannot update both an ALLBASE/SQL database and a TurboIMAGE/XL database within the same transaction. Such an attempt will produce an error.

Within a transaction, avoid a terminal read with locks in effect (DBOPEN mode 1 through 4 and isolation level of RR, CS, or RC) because the database could be locked for a lengthy period of time. See Table 5-1 “Assigned Locks” for details on locking assignment.

The limitation of transaction size depends on the Transaction Management (XM) limit and the DBE LOG SIZE limit. The XM limit for every transaction cannot exceed 4MBytes.

	NOTE: TurboIMAGE/XL activity is not logged to DBELOG.