skip to main content
Developing ODBC Applications : Using Scrollable Cursors : Using Static Scrollable Cursors
 

Using Static Scrollable Cursors

• The ODBC driver supports static cursors for all types of result set generating statements, including result sets generated by stored procedures.
• The ODBC driver supports LOB data for static cursors; however, by default, only the first 4096 bytes of the LOB column is buffered. See SLKStaticCursorLongColBuffLen for more information about specifying the amount of data that is buffered.
• To persist a result set as an XML data file with embedded schema, you must use static cursors. See See Using SQLPrepare/SQLExecute and SQLExecDirect for more information how sending arrays of parameters can improve performance. for more information about persisting XML data files.