602SQL Documentation Index  

CLOSE Statement (SQL)

statement_CLOSE ::= CLOSE cursor_name;

The CLOSE statement closes a specified cursor. The cursor_name must either be declared in the cursor declaration or must point to a query that belongs to the application stored in the database.

If the specified cursor is not open, the error sqlstate 34000 (SQ_INVALID_CURSOR_NAME) occurs.