Re: SQL Question - ILE

[R Bruce Hoffman <bruce.hoffman@xxxxxxxxxxxxxxxxx>]

Does the module end? If so, then check the CLOSQLCSR setting on the
compile. If not, then have you tried using aliases? If you must, RPG
does an implicit connect. Try disconnecting and reconnecting to the
database.


On Fri, 2006-12-08 at 12:39 -0800, Jeff Young wrote:
> 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