602SQL Documentation Index  

OPEN Statement (SQL)

statement_OPEN ::= OPEN cursor_name;

The OPEN statement opens a cursor and sets the cursor before the first result row. The cursor_name must be declared either in the cursor declaration or designate a query stored in the database.

If the specified cursor is already opened, the error sqlstate 24000 (SQ_INVALID_CURSOR_STATE) occurs.