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.