Show Cursor Settings (Stmt Menu)

The Show Cursor Settings function tool displays the value of all cursor parameters for the current cursor, including the cursor type, the cursor’s concurrency, the rowset size set for calls to SQLExtendedFetch, and the rowset size set for calls to SQLFetch or SQLFetchScroll. This tool performs the following actions:

1. Calls SQLGetStmtAttr with Attribute set to SQL_ATTR_CURSOR_TYPE.
   
   
2. Calls SQLGetStmtAttr with Attribute set to SQL_ATTR_CURSOR_CONCURRENCY.
   
   
3. Calls SQLGetStmtAttr with Attribute set to SQL_ATTR_ROW_ARRAY_SIZE.
   
   
4. Calls SQLGetStmtAttr with Attribute set to SQL_ROWSET_SIZE.