в \doc\sql.extensions\README.set_transaction.txt есть интересный пункт:
авторMore options exposed in the SET TRANSACTION command.

Syntax
========

SET TRANSACTION option_list

The command is used in DSQL to start a transaction without using the specialized
API call to create a new transaction. To the already existing options, the following
have been added. Notice this is not new functionality: it's available through the
TPB since years ago (they appear in ibase.h as items for TPBs). This extension
only makes those options available to clients that want to start a transaction by
executing a DSQL command, like isql's command prompt.

The new options exposed are:

NO AUTO UNDO: prevents the transaction from keeping an undo log that would be used
to undo its changes if it's rolled back. The net effect is undoing the changes, then
marking the transaction as committed. Without the undo logs, other transactions
reading the affected record will collect the garbage. This option is useful for
massive insertions when there's no need to roll back.

IGNORE LIMBO: ignores the records created by transactions in limbo. Typically a
transaction is in limbo when it's a multi-database transaction and the two phase
commit fails. This option is mostly used by gfix.

LOCK TIMEOUT nonneg_short_integer: it's the time (measured in seconds) that a
transaction waits for a lock in a record before giving up and reporting an error.

Правильно ли я понимаю, что у транзакции таки есть undo log? Я думал что у нас версионик без undo-лога :)
Правильно ли я понимаю, что NO AUTO UNDO - это по сути закоммиченая при старте транзакция, т.е. откатить её уже нельзя? И именно потому что она закоммичена, изменения сделанные ей и видны другим транзакциям?

ТаблоидИногда чтение sql.ru показывает, что... ничто не ново под Луной. В том числе и вопросы про no auto undo
Ага :) Вот по первой ссылке я и наткнулся на это :)