The first step to use a cursor in SQL DB2 stored procedures is to declare it. A cursor declaration consists of a name, a keyword CURSOR, and a SELECT statement that defines the query result set.

Call SQLSetStmtAttr to set the desired cursor attributes: Set the SQL_ATTR_CURSOR_TYPE and SQL_ATTR_CONCURRENCY attributes (this is the preferred option). Or Set the SQL_CURSOR_SCROLLABLE and ...