Progress
SQL-89
Guide and Reference
Opening a Cursor
The OPEN statement has the following general syntax.
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.
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 |