Restrictions [ IMAGE/SQL Administration Guide ] MPE/iX 5.5 Documentation
IMAGE/SQL Administration Guide
Restrictions
You can only modify one type of data in a transaction. That is, you can
do the following within the same transaction:
* Read a TurboIMAGE/XL and/or ALLBASE/SQL database and modify a
TurboIMAGE/XL database.
* Read a TurboIMAGE/XL and/or ALLBASE/SQL database and modify an
ALLBASE/SQL database.
[REV BEG]
You cannot update both an ALLBASE/SQL database and a TurboIMAGE/XL
database within the same transaction. Such an attempt will produce an
error.[REV END]
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
for details on locking assignment.
The limitation of transaction size depends on the Transaction Management
(XM) limit and the DBE LOG SIZE limit.[REV BEG] The XM limit for every
transaction cannot exceed 4MBytes.[REV END]
NOTE TurboIMAGE/XL activity is not logged to DBELOG.
MPE/iX 5.5 Documentation