Empties a temp-table.

When you empty a temp-table that is defined as UNDO within a transaction, the AVM deletes the records individually. This is less efficient than emptying the temp-table outside the transaction, where the AVM deletes all records in the temp-table as a unit.

Note: This statement corresponds to the EMPTY-TEMP-TABLE( ) method.

Syntax

EMPTY TEMP-TABLE temp-table-name [ NO-ERROR ]
temp-table-name
The name of the temp-table.
NO-ERROR
The NO-ERROR option is used to prevent the statement from raising ERROR and displaying error messages.

See also

EMPTY-TEMP-TABLE( ) method, NO-ERROR option