Allow Update And Delete
- 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
Allow Update And Delete
Attribute
AllowUpdateAndDelete (AUD)
Purpose
Allows Update and Delete statements. Because Update and Delete statements cause immediate changes to a text file, only one connection at a time can operate on a file. Each update and delete on a text file can cause significant changes to the file, and performance may be degraded. Consider a more appropriate database form if performance is a significant factor.
Valid Values
0 | 1
Behavior
If set to 1 (Enabled), text files are opened exclusively by the current connection.
If set to 0 (Disabled), Update and Delete statements are not allowed.
Default
0 (Disabled)