Locking
- Last Updated: October 3, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- Cloudera Impala 7.1
- dBase 7.1
- Flat files/Text 7.1
- MySQL 7.1
- Pervasive (Btrieve) 7.1
- XML 7.1
- Documentation
Attribute
Locking (LCK)
Purpose
The level of locking for the database file.
Valid Values
NONE | RECORD | FILE
- NONE offers the best performance, but is intended only for single-user environments. See Locking for details.
- RECORD locks only the records affected by the statement.
- FILE locks all of the records in the table.
Default
RECORD