Progress
Language Reference


EMPTY TEMP-TABLE Statement

Interfaces
OS
SpeedScript
All
All
Yes

Empties a temp-table.

Temp-tables defined as NO-UNDO can be emptied within a transaction. Temp-tables that are defined as UNDO or default to UNDO can only be emptied as long as no transaction is active, whether or not it involves records in the temp-table.

SYNTAX
EMPTY TEMP-TABLE temp-table-name [ NO-ERROR ] 

temp-table-name

The name of the temp-table.

NO-ERROR

Specifies that any errors that occur in the attempt to empty the temp-table are suppressed. After the EMPTY TEMP-TABLE statement completes, you can check the ERROR-STATUS system handle for any errors that occurred.

SEE ALSO

EMPTY-TEMP-TABLE( ) Method


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095