Select Code to Download

$myarrayref = [ 
   { NAME => 'Bob' , JOB => 'Programmer'} ,
   { NAME => 'Bill' , JOB => 'Manager'} ,
];

$template->param( EMPLOYEE_INFO => $myarrayref);

# Create statement handle
$sth = $dbh->prepare($somesql);
...

# clean up statement handle
$sth->finish();

$template->param(EMPLOYEE_INFO => $myarrayref);