OPEN cursor-name
cursor-name: identifier, or host variable
To open a cursor.
DECLARE, PREPARE, FETCH, CLOSE, DROP.
This command opens a previously declared cursor to access information from a database. The cursor must have been DECLAREd, and the associated statement must have been prepared.
All cursors are opened WITH HOLD, that is, they are left open and at the same row if a COMMIT or ROLLBACK is performed.
When opened, the cursor is positioned just before the first row of the result set.
This command is functionally similar to the Embedded SQL command OPEN. See "OPEN statement".