Set the row or page lock mode for all CREATE TABLE statements

HCL Informix® allows you to set the lock mode to page-level locking or row-level locking for all newly created tables for a single user (per session) or for multiple users (per server). You no longer need to specify the lock mode every time that you create a new table with the CREATE TABLE statement.

If you want every new table created within your session to be created with a particular lock mode, you have to set the IFX_DEF_TABLE_LOCKMODE environment variable. For example, for every new table created within your session to be created with lock mode row, set IFX_DEF_TABLE_LOCKMODE to ROW. To override this behavior, use the CREATE TABLE or ALTER TABLE statements and redefine the LOCK MODE clause.