EMPTY TEMP-TABLE statement

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.

EMPTY TEMP-TABLE statement

Syntax

See also