SQL Question - ILE

I have an ILE RPG SQL module that selects data from files using SQL.
The data is selected either by the Select INTO or other methods that do not use 
a cursor.
Based on a field in my input, the actual files I am using will be overriden to 
different files with the exact same format, but different names.
The problem I seem to be having, is that even though the override is in effect 
at the activation group level, the open files for the job show only the first 
set of files.
In addition, when I attempt to retreive data from the 2nd set of files, the 
query seems to be ignoring the override and using the first set.
Is there any way I can force the files to close when I need to change overrides?

Thanks,
 
Jeff Young 
Sr. Programmer Analyst
Dynax Solutions, Inc.
A wholly owned subsidiary of enherent Corp.
IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions V5R2 
IBM  Certified Specialist- e(logo) server i5Series Technical Solutions Designer 
V5R3
IBM  Certified Specialist- e(logo)server i5Series Technical Solutions 
Implementer V5R3


 
____________________________________________________________________________________
Yahoo! Music Unlimited
Access over 1 million songs.
http://music.yahoo.com/unlimited