OPEN — open a dynamic cursor
value[, ... ] OPEN
cursor_nameUSING SQL DESCRIPTOR
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
The execution of
OPEN causes the
query to start executing on the server.
The name of the cursor to be opened. This can be an SQL identifier or a host variable.
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.
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.
EXEC SQL OPEN a; EXEC SQL OPEN d USING 1, 'test'; EXEC SQL OPEN c1 USING SQL DESCRIPTOR mydesc; EXEC SQL OPEN :curname1;
OPEN is specified in the SQL
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.