Precedence and Default Behavior

The LOCK MODE setting in an ALTER TABLE statement takes precedence over the settings of the IFX_DEF_TABLE_LOCKMODE environment variable and the DEF_TABLE_LOCKMODE configuration parameter. For information about the IFX_DEF_TABLE_LOCKMODE environment variable, refer to the HCL OneDB™ Guide to SQL: Reference. For information about the DEF_TABLE_LOCKMODE configuration parameter, refer to the HCL OneDB Administrator's Reference.