Opening a cursor

A cursor must be opened before it can be used.

The OPEN statement is used to open a cursor. The values for host variables in the cursor description and for special literals (see "Special literals") and time functions (CURRENT_DATE, CURRENT_TIME(3), CURRENT_TIMESTAMP(3), etc.) are determined. After a cursor is opened, it is positioned before the first row of the corresponding cursor table (see section “OPEN - Open cursor”).