Alias not allowed in export script in Peoplesoft Data mover

Hi,

Could you please tell me why Peoplesoft Data mover does not allow the usage of aliases in export script? If used, it gives syntax error.

Ex: EXPORT PS_PERSON A WHERE A.EMPLID IN (SELECT B.EMPLID FROM PS_PERS_NID B WHERE B.NATIONAL_ID_TYPE = 'PR')

The above export script when run in Peoplesoft Data mover gives syntax error. However, it runs successfully if alias A is not used to refer table PERSON.

i.e the Export script below works fine:

EXPORT PS_PERSON  WHERE EMPLID IN (SELECT B.EMPLID FROM PS_PERS_NID B WHERE B.NATIONAL_ID_TYPE = 'PR')