Truncate Table Messages

The table cannot be truncated if it has an open cursor or dirty readers.

Cause:

You must have exclusive access to the table.

Action:

Wait for dirty readers to complete or close all the open cursors and reissue the TRUNCATE TABLE command.

The table cannot be truncated. It has at least one non-empty child table with referential constraints.

Cause:

You cannot truncate a table if it has child tables with referential constraints and at least one row.

Action:

Empty the child tables before you truncate this table.