> How is subj supposed to work? I see that it forces engine to start a > transaction and that's all.
It maintains all the rdb$db_key values for the length of a connection - i.e. they are not allowed to change. An internal transaction gets started for this. It was introduced to support Cognos' Powerhouse 4GL product which made extensive use of db_keys. Obviously it can have issues re. garbage collection... Regards Paul Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel