OPEN statement

Description

Includes syntax added for row pre-fetching.

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.