my $yi = $dbh->prepare("

SELECT SSN, RTRIM(LAST_NAME,' '), TO_CHAR(BIRTH_DATE,'YYYY'), STORE
FROM PYHADMIN.PY_EMP_SHADOW
where TO_CHAR(BIRTH_DATE,'YYYY') like '$year'
and SSN like '%$ssn'
and RTRIM(LAST_NAME,'  ') like upper('$name')
and rownum <= 1

        ");
$yi->execute();