open scrollable cursor

Description

Opens a previously declared static cursor.

Syntax

EXEC SQL OPEN <cursor_name> [ ROW_COUNT = size ] END-EXEC

Parameters

size

Specified as the pre-fetch count. The value is the same as the host array size.

ROW_COUNT

Specified only when host arrays are used as host variables.

Usage

The size value is the same as the host array size.

See also

scroll fetch, declare