Release 10.1A: OpenEdge Development:
Progress 4GL Reference

> ## EMPTY TEMP-TABLE statement

> 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.

> 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`

> 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 © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095