The CLOSE statement closes a cursor. If a result table was created when the cursor was opened, that table is destroyed.
For more information, see CLOSE in the SQL Reference topic in the Information Center.