|
EXEC SQL CLOSE cursor_name ;
|
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.
|
EXEC SQL CLOSE dyncur ;
EXEC SQL COMMIT WORK ; |
