def fetch_scroll(direction, offset)
direction = case direction
when DBI::SQL_FETCH_FIRST then ::DB2CLI::SQL_FETCH_FIRST
when DBI::SQL_FETCH_LAST then ::DB2CLI::SQL_FETCH_LAST
when DBI::SQL_FETCH_PRIOR then ::DB2CLI::SQL_FETCH_PRIOR
when DBI::SQL_FETCH_NEXT then ::DB2CLI::SQL_FETCH_NEXT
when DBI::SQL_FETCH_RELATIVE then ::DB2CLI::SQL_FETCH_RELATIVE
when DBI::SQL_FETCH_ABSOLUTE then ::DB2CLI::SQL_FETCH_ABSOLUTE
else
raise InterfaceError, "wrong direction"
end
do_fetch(SQLFetchScroll(@handle, direction, offset))
end