in reply to sql record sets

DBI doesn't support scrollable cursor, if that's what you're looking for. If you want to "walk" on the result set, you may consider using the $dbh->selectall_arrayref() method which returns the whole result set as an array ref of array refs.
use Data::Dumper; ... $rows = $dbh->selectall_arrayref("SELECT ..."); # the first row: print Dumper $rows->[0];

Update: fixed typo