HP 3000 Manuals

HP IMAGE/SQL Administration Guide

Restrictions 
[REV BEG]

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.

However, you cannot update an ALLBASE/SQL database and update 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  
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 2MBytes, which is approximately 100 "normal"
DBPUT, DBDELETE, and DBUPDATE intrinsics combinations.


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

[REV END]

MPE/iX 5.0 Documentation