8. SQL Statements : CLOSE : Description
 
Share this page                  
Description
The cursor_name must have been previously defined in your source file by a DECLARE CURSOR statement. Once closed, the cursor cannot be used for further processing unless reopened with a second OPEN statement. A COMMIT, ROLLBACK, or DISCONNECT statement closes all open cursors.
A string constant or host language variable can be used to specify the cursor name.