Progress
SQL-89
Guide and Reference


Opening a Cursor

The OPEN statement has the following general syntax.

SYNTAX
OPEN cursor-name 

The OPEN statement positions the cursor before the first row of the retrieval set. The retrieval set is the set of records that results from executing SELECT in the DECLARE CURSOR statement. Progress/SQL uses current values for any procedure variables that you refer to in the SELECT statement to yield the retrieval set.

The following example opens the previously declared cursor.

OPEN c1. 

You can open and close a cursor multiple times after you declare it. Each time you open the cursor, the SELECT statement is re-executed. Therefore, you do not have to declare the cursor more than once. With each execution, the retrieval set might contain different data if the values referenced in the SELECT statement have changed.

NOTE


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