Progress
Embedded SQL-92
Guide and Reference


OPEN a Cursor

The OPEN statement sets a cursor to the open state. When a cursor is opened, the SELECT statement associated with the cursor is executed producing a result set. This result set is referred to as the active set. Executing the SELECT statement uses the current program variables and leaves the cursor positioned just before the first row in the active set.

When the cursor is in the open state, any changes to the program variables of the SELECT statement do not change the rows retrieved in the active set.

EXAMPLE

The following example shows an OPEN operation on the cursor custcur:

/*
** Open the cursor
*/
EXEC SQL
     OPEN custcur ; 


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