OPEN

The OPEN statement is used in SQL Script to open a cursor. Two types of OPEN statements are available, one to open a static cursor and another to open a variable cursor. The OPEN statement for a variable cursor can specify whether it is for a query expression or a value expression. See Value Expressions.

Syntax (Open Static Cursor)

OPEN <cursor>

Syntax (Open Variable Cursor)

OPEN <cursorVariableName> FOR <queryExpression>

Remarks

•

A cursor variable can be opened and initialized using a dynamic SQL statement as follows:

OPEN <cursorVariableName> FOR <valueExpression>

•

OPEN is similar to preparing a statement for execution.

•

Run-time errors, such as insufficient privileges, are not caught until a statement is executed.

•

The syntax for the open static cursor statement works on both static and variable cursors, although you get an error if you open an uninitialized cursor variable.

•

It is illegal to open a cursor that is already open.

Errors

Standard parser and resolver errors can result from the SELECT statement in the FOR clause. The following table describes the errors that can occur when executing an OPEN statement.

Error Message	Cause
Cannot open a PIPE	An attempt is made to open a PIPE variable.
Uninitiallized cursor	A cursor variable is used and is not initialized at the time it is opened.
Cursor already open	OPEN was invoked when the cursor was already open.