A transaction accesses the rows visible in its snapshot.
Transactions can be simple, multi-table or composite:
- Simple transactions involve a single RLV-enabled table and the RLV store only.
The log records exist entirely in a single log stream.
- Multi-table transactions involve multiple RLV-enabled tables, and contain
records in multiple log streams.
- Composite transactions involve traditional IQ tables (with table-level
versioning), SAP Sybase SQL Anywhere® tables (in the IQ
catalog store), and RLV-enabled tables coexisting in the same transaction. The
server commits the TLV tables, followed by the
SQL Anywhere tables and finally, the RLV-enabled
tables.