makes a result set from an SQL query.
Details and Options
- To use SQLResultSetOpen, you first need to load DatabaseLink using Needs["DatabaseLink`"].
- The following options can be given:
"Mode" "ScrollInsensitive" the timeout for the query "FetchDirection" Automatic processing direction hint to JDBC driver "FetchSize" Automatic JDBC driver hint for filling result sets
Examplesopen allclose all
Basic Examples (2)
If you find that the examples in this section do not work as shown, you may need to install or restore the example database with the DatabaseLink`DatabaseExamples` package, as described in Using the Example Databases.
Use SQLSelect instead of SQLExecute:
Specify one of "ForwardOnly", "ScrollInsensitive", or "ScrollSensitive", depending on whether the desired result set is scrollable and sensitive to changes in the underlying data:
The mode "MySQLStreaming" is supported by some MySQL drivers. This unscrollable mode is suitable for streaming large result sets with low memory use:
Compute memory in use, including both kernel and Java layers:
Read a conventional forward-only result set 100 rows at a time:
Memory use is relatively high, as the driver is keeping a copy of the result set in memory:
Read the result set in streaming mode: