#execute statement here
my @data = (); # define an array
while(my $row = $sth->fetchrow_hashref()) {
     push(@data,$row);
}

# finish and disconnect