OPEN

Name

OPEN -- open a dynamic cursor

Synopsis

OPEN cursor_name
OPEN cursor_name USING value [, ... ]
OPEN cursor_name USING SQL DESCRIPTOR descriptor_name

Description

OPEN opens a cursor and optionally
binds actual values to the placeholders in the cursor's
declaration. The cursor must previously have been declared with
the DECLARE command. The execution of
OPEN causes the query to start executing
on the server.

Parameters

cursor_name

The name of the cursor to be opened. This can be an SQL
identifier or a host variable.

value

A value to be bound to a placeholder in the cursor. This
can be an SQL constant, a host variable, or a host variable
with indicator.

descriptor_name

The name of a descriptor containing values to be bound
to the placeholders in the cursor. This can be an SQL
identifier or a host variable.

Compatibility

See Also

Submit correction

If you see anything in the documentation that is not correct, does not match
your experience with the particular feature or requires further clarification,
please use
this form
to report a documentation issue.