Single-user lock mode

Set the single-user lock mode if all of the new tables that you create in your session require the same lock mode. Set the single-user lock mode with the IFX_DEF_TABLE_LOCKMODE environment variable. For example, for every new table created within your session to be created with row-level locking, 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. For more information on setting environment variables, see the HCL OneDB™ Guide to SQL: Reference.