Opening a Cursor

OPEN statement

After the SQL DECLARE CURSOR command has associated a cursor with a selection of data, you use the SQL OPEN statement to get ready to retrieve the data. These commands for a particular cursor:

• Must appear in the same OLAP DML program.

• Cannot contain ampersand substitution.

The following is the syntax of the SQL command with an OPEN statement as an argument.

SQL OPEN cursor-name

Cursor's active set

The SQL OPEN command:

• Evaluates the input host variables (if any) used in the definition of the specified cursor.

• Determines the cursor's active set (that is, the rows that satisfy the SELECT statement).

• Leaves the cursor positioned before the first row of the active set.

A cursor's active set is determined when it is opened, and it is not updated later. Therefore, changing the value of an input host variable after opening its cursor does not affect the cursor's active set.