The IOM driver supports
scrolling by following the standard JDBC syntax for ResultSet.TYPE_SCROLL_INSENSITIVE.
The
SAS/SHARE driver does not support scrolling.
Note: Requests for ResultSet.TYPE_SCROLL_SENSITIVE
are not supported. Those result sets are returned with ResultSet.TYPE_SCROLL_INSENSITIVE.
When you use connection.createStatement,
if the underlying data store does not support the requested scrolling
type or concurrency, then the JDBC driver sets the scrolling type
or concurrency to something that is supported. This JDBC specification
requirement means that it is a best practice to check the statement
object's values for getResultSetType and getResultSetConcurrency to
avoid unexpected results.