Opens a previously declared static cursor.
EXEC SQL OPEN <cursor_name> [ ROW_COUNT = size ] END-EXEC
Specified as the pre-fetch count. The value is the same as the host array size.
Specified only when host arrays are used as host variables.
The size value is the same as the host array size.
scroll fetch, declare