$ssn = q{%} . $ssn;

my $sql = <<"END"
SELECT 
  SSN, RTRIM(LAST_NAME,' '), 
  TO_CHAR(BIRTH_DATE,'YYYY'), 
  STORE
FROM 
  PYHADMIN.PY_EMP_SHADOW
where 
      TO_CHAR(BIRTH_DATE,'YYYY') like ?
  and SSN like ?
  and RTRIM(LAST_NAME,'  ') like upper(?)
  and rownum <= 1
END
;
my $yi = $dbh->prepare($sql);
$yi->execute($year, $ssn, $name );