Progress
Embedded SQL-92
Guide and Reference
CLOSE Statement
Closing a cursor changes the state of the cursor from open to closed.
SYNTAX
cursor_name
An identifier named earlier in a
EXAMPLEDECLARE CURSOR
statement and anOPEN CURSOR
statement.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."
NOTES
- Only a cursor in the open state can be set to the closed state.
- When a transaction ends, any cursors in the open state are automatically set to the closed state.
- When a cursor is in the closed state, you cannot perform FETCH, DELETE, or UPDATE operations using that cursor.
- It is good practice to close cursors explicitly.
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 |