Try OpenEdge Now
skip to main content
SQL Development
Data Control Language and Transaction Behavior : Authorized Data Truncation : Logging


When a DBA-authorized data truncation occurs and if logging is enabled for the data truncation, the table name, column name, rowid, partition ID, and tenant ID of any row containing a truncated data value is logged.
Note: Enabling logging for data truncation may result in performance degradation of SQL server process. If there is a large amount of data truncation, a large amount of information is written to the log file, which may cause SQL server process to slow down.