Progress
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 sample program, 4DynSel.pc, is listed in Appendix A of the Progress Embedded SQL-92 Guide and Reference .

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 Statement, positioned DELETE Statement


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