Hi Norman,
You can use various SHOW commands in isql to query database metatdata.
Metatdata is stored in system tables. When a SHOW command is issued,
isql commits the current transaction and begins a new one, in READ
COMMITTED isolation.
As you showed below, this is not (always) true. Maybe
On 18/07/11 14:37, Dmitry Yemanov wrote:
SHOW commands operate on a separate transaction from user statements.
They run as READ COMMITTED background statements and acknowledge all
metadata changes immediately.
Thanks. I've updated the isql manual with these details.
Cheers,
Norm.
--
Norman