Cursor functions control Connect CDC (SQData) cursor processing at runtime, including opening a cursor, retrieving rows, closing the cursor, and iterating through the result set.
| Function | Description |
|---|---|
| CLOSE | Closes an open cursor and releases the resources associated with the current query. |
| FETCH | Retrieves the next row from an open cursor and returns the normalized Connect CDC (SQData) fetch status. |
| FOREACH | Iterates over a cursor and executes the statement body once for each fetched row. |
| OPEN | Opens a cursor defined by a CREATE CURSOR statement so it can be processed row by row. |