OPEN Statement

The OPEN statement opens an explicit cursor, allocates database resources to process the associated query, identifies the result set, and positions the cursor before the first row of the result set. (If the query has a FOR UPDATE clause, processing the query includes locking the rows of the result set—see "SELECT FOR UPDATE and FOR UPDATE Cursors".)

Topics:

• Syntax

• Semantics

• Examples

• Related Topics

Syntax

open_statement ::=

Description of the illustration open_statement.gif

Semantics

cursor_name

The name of an explicit cursor that is not open.

actual_cursor_parameter

An actual parameter that corresponds to a formal parameter of the explicit cursor cursor_name. For more information, see "Explicit Cursors that Accept Parameters".

Examples

• Example 6-6, "Opening an Explicit Cursor"

Related Topics

In this chapter:

• "CLOSE Statement"

• "Explicit Cursor"

• "FETCH Statement"

• "OPEN FOR Statement"

In other chapters:

• "Opening Explicit Cursors"