Progress
SQL-89
Guide and Reference


Closing a Cursor

The CLOSE statement has the following general syntax.

SYNTAX
CLOSE cursor-name 

This statement closes the cursor. You cannot refer to the cursor again unless you open it. If you reopen it, Progress/SQL re-evaluates the selection criteria for the retrieval set and repositions the cursor before the first row. All open cursors are closed when you exit from the procedure.

The following statement closes cursor c1.

CLOSE c1. 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095