Truncate Table errors
Go Up to Truncate Table
A lock error returns if an exclusive table lock cannot be acquired during the locking phase. The error returned can be a
isc_deadlock error or a transaction wait error depending on the transaction's wait mode. If a transaction waits indefinitely for lock acquisition, it can only return a
isc_deadlock error due to a real deadlock with a concurrent transaction.
If the transaction is
NO WAIT, it returns an
isc_lock_conflict error immediately. If the transaction requests a
WAIT TIME, it returns
isc_lock_timeout when waiting the specified time for table lock acquisition.
It is also an error to execute a Truncate Table command from a
READ_ONLY transaction or database. During the truncation phase there is no expected way for an error to occur. However, unexpected errors can occur due to extraneous circumstances.
If a transaction executing a Truncate Table command has open cursors on one or more of the truncated tables, attempting to perform an
UPDATE on those open cursors can return an
isc_table_truncated. Otherwise, if the fetch from the cursor is only for retrieval purposes, the fetch operation returns as if there were no more remaining rows to fetch.