Not sure about the bind variables, but the first bit should look like this:

$query = <<'END';
select date, run_time, run_dis, num_push,
       num_sit, abs, comment, workout_id, scored
from "cshaws_Schema"."log2"
where pid = ? order by date
END

$sth = $dbh->prepare($query);
$sth->execute($pid);
[download]