# You can execute a statement handle # and save it to a file with this. use SthFile; my $query = qq{ SELECT * FROM TABLE}; my $sth = $dbh->prepare($query) or die "Cant prepare query: $query\n $DBI::errstr"; $sth->execute() or die "Cant execute query: $query\n $DBI::errstr"; SthFile::sth_to_file({ sth => $sth, file_name => "/tmp/my_query.store", }); # And later, in some other program or place my $sth_from_file = new SthFile("/tmp/my_query.store") or die "Cant get some garbage.";