Problem using OVRDBF and ALIAS in a RPG program

I have a program that reads File_A which has multiple members.



There is a CL program before the SQLRPGLE program that does a OVRDBF FILE_A
to member B. In the program, I use a SQL SELECT to total up the balance on
an invoice which is SUMed against member A.



I create an ALIAS - CREATE ALIAS QTEMP/FILE_A_A for LIB/FILE_A(A) in the RPG
program.



In the program, I do a SELECT sum(AMT) from QTEMP/FILE_A_A.



Problem:

When the OVRDBF is used, the SELECT does not find the records. It seems to
be looking at member B in File_A.

When I remove the OVRDBF, the SELCT works as designed.



Does anyone know what the problem is and how to work around the issue?



TIA



Darryl Freinkel.