Show TOC

CLOSE Statement (close_statement)Locate this document in the navigation structure


The CLOSE statement ( close_statement) deletes a result table.

  CLOSE [<result_table_name>]


  • Result table name specified: This result table is deleted. This name can be used to denote another result table.

  • No result table name specified: An existing unnamed result table is deleted.

An unnamed result table is implicitly deleted by the next SELECT statement.

Result tables are implicitly deleted when a result table with the same name is generated.

All results tables generated within the current transaction are deleted implicitly at the end of the transaction using the ROLLBACK statement.

All results tables are deleted implicitly at the end of the session using the RELEASE statement.

More Information