The log is showing an error in the from statement as if enrhist library does not exist. It does exist and table aenr0809 is there. ??
create table aenr as
select distinct schoolattn, datepart(effdate) as effdate, entercode, leavecode, transyear, grade,
from enrhist.aenr0809 where entercode ne '' or leavecode ne '' and effdate ne . and schnum=schoolattn
order by permnum, effdate desc, leavecode desc, entercode, schoolattn;