When you execute a query, you are implicitly opening a Cursor.
-
About SQL/CLI: Cursor Functions
When you execute a query, you are implicitly opening a Cursor. For example,... -
SQLFetch
Function Prototype: SQLRETURN SQLFetch ( SQLHSTMT hstmt ... -
Fetch Loops
When dealing with a result set, the procedure is almost always to: make a r... -
SQLFetchScroll
Function Prototype: SQLRETURN SQLFetchScroll( SQLHSTMT hstmt, -
SQLCloseCursor
Function Prototype: SQLRETURN SQLCloseCursor( SQLHSTMT hstmt ... -
SQLGetCursorName
Function Prototype: SQLRETURN SQLGetCursorName( SQLHSTMT hstmt, -
SQLSetCursorName
Function Prototype: SQLRETURN SQLSetCursorName( SQLHSTMT hstmt, -
Embedded SQL versus CLI
Here is an embedded SQL example which uses a Cursor: EXEC SQL DECLARE x -
SQLMoreResults
Function Prototype: SQLRETURN SQLMoreResults( SQLHSTMT hstmt /* 32-...
