CLOSE CURSOR in Teradata

When the cursor is no longer needed, it is a good idea to free up the SPOOL containing the rows of the OPEN request. This is accomplished using an CLOSE statement. Its syntax is below:

CLOSE <cursor name>;


Example:
CLOSE cur_select_emp;