The Set Cursor Attributes function tool sets the statement attributes affecting cursor operation. This tool performs the following action:
| Attribute | Settings |
| SQL_ATTR_CURSOR_TYPE | SQL_CURSOR_FORWARD_ONLY SQL_CURSOR_STATIC SQL_CURSOR_KEYSET_DRIVEN SQL_CURSOR_DYNAMIC |
| SQL_ATTR_CONCURRENCY | SQL_CURSOR_READ_ONLY SQL_CURSOR_LOCK SQL_CURSOR_ROWVER SQL_CURSOR_VALUES |
| SQL_ATTR_USE_BOOKMARKS | SQL_UB_OFF SQL_UB_ON SQL_UB_VARIABLE |
| SQL_ATTR_ROW_BIND_TYPE | SQL_BIND_BY_COLUMN (column-wise binding) - or - The length of a structure or an instance of a buffer into which result columns will be bound (row-wise binding) |
| SQL_ATTR_ROW_ARRAY_SIZE | Rowset size for SQLFetchScroll or SQLFetch |
| SQL_ROWSET_SIZE | Rowset size for SQLExtendedFetch |