Progress
Embedded SQL-92
Guide and Reference


CLOSE Statement

Closing a cursor changes the state of the cursor from open to closed.

SYNTAX

EXEC SQL CLOSE cursor_name ; 

cursor_name

An identifier named earlier in a DECLARE CURSOR statement and an OPEN CURSOR statement.

EXAMPLE

This example is a code fragment from the seldone routine in the sample program 4DynSel.pc. The complete source for the sample program in "ESQL-92 Sample Programs."

EXEC SQL CLOSE dyncur ;
EXEC SQL COMMIT WORK ; 

NOTES

AUTHORIZATION

None. See AUTHORIZATION for the OPEN Statement.

SQL COMPLIANCE

SQL-92

ENVIRONMENT

Embedded SQL-92 only

RELATED STATEMENTS

DECLARE CURSOR Statement, OPEN Statement, FETCH Statement, positioned UPDATE, positioned DELETE


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