informix 关于锁的模式

关于锁模式 SHARE模式和EXCLUSIVE模式的描述。

The LOCK TABLE statement fails if the table is already locked in EXCLUSIVE

mode by another process, or if you request an EXCLUSIVE lock while another
user has locked the same table in SHARE mode.

The SHARE keyword locks a table in shared mode. Shared mode gives other
processes read access to the table but denies write access. Other processes
cannot update or delete data if a table is locked in shared mode.

The EXCLUSIVE keyword locks a table in exclusive mode. This mode denies
other processes both read and write access to the table. Exclusive-mode
locking automatically occurs during the ALTER INDEX, ALTER TABLE,
CREATE INDEX, DROP INDEX, RENAME COLUMN, RENAME TABLE, START
VIOLATIONS TABLE, and STOP VIOLATIONS TABLE statements.

摘自：
        IBM Informix Guide to SQL Syntax
        IBM Informix Extended Parallel Server, Version 8.4
        IBM Informix Dynamic Server, Version 9.4

在4gl的Transaction中、默认是SHARE模式。

如果要变成EXCLUSIVE模式，需要用命令进行修改。

命令如下：  LOCK TABLE xxxxxx in exclusive mode

其中，xxxxxx 是表名。